The Import XLS feature is used to convert one or more data sources from XLS files type in a structured database, in a fast and secure way.
The tool will import the data saved in XLS files to one of the following databases: MySQL, PostgreSQL, SQLite and SQL Server
In the first step we need to select the XLS data source that we want to import, to import the XLS file you must use one of the options below to load the data source.
In the second step we will identify the internal format of the file and choose the desired tables, review the types of data, display data and make necessary adjustments.
By moving to the second step, Scriptcase will automatically display the tables found in the previously selected source data. We have the option to select the desired tables, review the types of data, visualize data and make necessary adjustments.
In the "Tables" tab all available tables will be displayed for import into the edit option and we can change the field names, data type, size, primary key, auto-increment and set how many rows of source data will be read.
On the "Advanced" tab, there are settings available to add DROP TABLE before creating the tables, if we wish to recreate the structure and data, if we wish to recreate or just recreate the structure only data.
In the third step we will configure the connection in which we want to import the selected data source. Select a connection from the existing database design or create a new connection to receive the converted data source chosen in the previous step.
It is possible to create a new connection for MySQL, SQLite, Postgress and MSSQL (SQL Server) banks.