Imprimir

Import Database

This tool allows you to convert the stored tables in .XLS, .CSV, .accdb and .mdb files to the following databases: MySQL, PostgreSQL, SQLite and SQL Server.

All the options to import databases, you can find them in the menu Database.

Access Import

Allows you to convert one or more data sources to one structured database.

Selecting Files

First, inform the files that’ll be converted. You can inform the absolute path to the file, drag’n drop the file or select the file in the option Select Files.

Selecting an access file to convert the tables

Configuring the tables

After selecting the file, you need to access the configuration page.

On this page, you’ll see the password field, that’s used only with ACCESS files that were selected and require a password to list the tables. In these cases, after informing the password, click on list tables.

Table Passwords

Still in the same page, you can view the tabs Tables and Advanced.

Table List

Table Tabs

We can view a list of the tables that can be converted. Beside the name of the tables, are two options: Edit and Preview.

On the option Edit, you can modify the table structure that’ll be created, like the name, field size, and the data type and other options.

Edit the structure of the created tables

in Preview you’ll see a preview of how the table will be imported.

Preview of the table that'll be created

Advanced Tab

On the “Advanced” tab are available the configurations import script for the table. You can configure the script that’ll be created for the generation of the tables of new database.

Advanced Configuration for the script creation

  • Add DROP TABLE - Adds a DROP TABLE IF EXISTS before the CREATE of the tables, so that if the tables exist with the same name in the database, they’ll be deleted first.
  • Recreate the database structure - Where you’ll define the table structure and the data that’ll be imported.
  • Recreate the structure - Where you’ll define only the structure the table that’ll be imported.
  • Recreate data - Where you’ll define only the data of the tables that’ll be imported (In case the tables exist in the database with the same structure of the ones being imported)

Connection

On this step, we need to select the connection (Database) to where you’ll import the tables. You can select a connection existing in the project or create a new one.

Selecting a connection to import to

Next, you’ll be presented with a log of the tables that have been imported and the total of records inserted.

Log of tables and records created

XLS Import

Allows you to convert one or more data sources to one structured database.

Selecting Files

First, inform the files that’ll be converted. You can inform the absolute path to the file, drag’n drop the file or select the file in the option Select Files.

Selecting an access file to convert the tables

Configuring the tables

After selecting the file, you need to access the configuration page.

On this page, you need to inform first the line that the name of the columns are, this way all the information that’s below will be considered a record of the table. If you don’t inform the line, all the file content will be considered a record.

Inform the line of the columns of the table

Still in the same page, you can view the tabs Tables and Advanced.

Table List

You can view below the list of tables of the files, with the names of the tables and the name of the file. In the case of XLS or CSV files, the table names are obtained through the name of the tab in the file.

Table Tabs

We can view a list of the tables that can be converted. Beside the name of the tables, are two options: Edit and Preview.

On the option Edit, you can modify the table structure that’ll be created, like the name, field size, and the data type and other options.

Edit the structure of the created tables

in Preview you’ll see a preview of how the table will be imported.

Preview of the table that'll be created

Advanced Tab

On the “Advanced” tab are available the configurations import script for the table. You can configure the script that’ll be created for the generation of the tables of new database.

Advanced Configuration for the script creation

  • Add DROP TABLE - Adds a DROP TABLE IF EXISTS before the CREATE of the tables, so that if the tables exist with the same name in the database, they’ll be deleted first.
  • Recreate the database structure - Where you’ll define the table structure and the data that’ll be imported.
  • Recreate the structure - Where you’ll define only the structure the table that’ll be imported.
  • Recreate data - Where you’ll define only the data of the tables that’ll be imported (In case the tables exist in the database with the same structure of the ones being imported)

Connection

On this step, we need to select the connection (Database) to where you’ll import the tables. You can select a connection existing in the project or create a new one.

Selecting a connection to import to

Next, you’ll be presented with a log of the tables that have been imported and the total of records inserted.

Log of tables and records created

CSV Import

Allows you to convert one or more data sources to one structured database.

Selecting Files

First, inform the files that’ll be converted. You can inform the absolute path to the file, drag’n drop the file or select the file in the option Select Files.

Selecting an access file to convert the tables

Configuring the tables

After selecting the file, you need to access the configuration page.

On this page, you need to inform first the line that the name of the columns are, this way all the information that’s below will be considered a record of the table. If you don’t inform the line, all the file content will be considered a record.

Inform the line of the columns of the table

Still in the same page, you can view the tabs Tables and Advanced.

Table List

You can view below the list of tables of the files, with the names of the tables and the name of the file. In the case of XLS or CSV files, the table names are obtained through the name of the tab in the file.

Table Tabs

We can view a list of the tables that can be converted. Beside the name of the tables, are two options: Edit and Preview.

On the option Edit, you can modify the table structure that’ll be created, like the name, field size, and the data type and other options.

Edit the structure of the created tables

in Preview you’ll see a preview of how the table will be imported.

Preview of the table that'll be created

Advanced Tab

On the “Advanced” tab are available the configurations import script for the table. You can configure the script that’ll be created for the generation of the tables of new database.

Advanced Configuration for the script creation

  • Add DROP TABLE - Adds a DROP TABLE IF EXISTS before the CREATE of the tables, so that if the tables exist with the same name in the database, they’ll be deleted first.
  • Recreate the database structure - Where you’ll define the table structure and the data that’ll be imported.
  • Recreate the structure - Where you’ll define only the structure the table that’ll be imported.
  • Recreate data - Where you’ll define only the data of the tables that’ll be imported (In case the tables exist in the database with the same structure of the ones being imported)

Connection

On this step, we need to select the connection (Database) to where you’ll import the tables. You can select a connection existing in the project or create a new one.

Selecting a connection to import to

Next, you’ll be presented with a log of the tables that have been imported and the total of records inserted.

Log of tables and records created