Here you can find the detailed instruction on how to export/import Microsoft Excel table(s) to Firebird database. The data migration from Excel to other database types like SQLite, PostgreSQL, Oracle, etc is very similar; the difference is in registering the database in Exportizer.

Below, it is shown how to export data directly (from GUI or command line), or using clipboard.

Export Conditions

In most cases, to export from Excel to Firebird, the following conditions are required:

Configuring Excel to Firebird Exporting

  1. If the target database does not exist yet, create a target .fdb file using the corresponding application.
  2. Launch Exportizer.
  3. Register your source Excel database. It can be an .xls, .xslx, .xlsb, or .xlsm file. See the links at the end of the topic to learn the possible options and troubleshooting.
  4. Register your target Firebird database. This must be a database from step 1. The recommended interface is FD, but other options are also available. Basically, you specify a server, a database (i.e. file path), and charset. Note: You can register the target database from the Export dialog during the exporting.

Export Steps

  1. Open the registered Excel database.
  2. Chose a table or tables to export or write and execute your SQL query.
  3. Click Export button.
  4. Go to the Database tab and select your registered Firebird database as a target database.
  5. Specify a target table (for multi-table exporting, you can leave this field blank). Turn on Memory saving mode option. Choose the correct Export mode.
  6. Click Next. For multi-table exporting, specify the source-to-target table mappings, otherwise check the source-to-target field mappings.
  7. Click Export.

Exporting Excel to Firebird from Command Line

Here are some examples of exporting data from an .xlsx file to Firebird database.

Exporting a table from Excel file to existing Firebird database:

"C:\Program Files (x86)\Vitaliy Levchenko\Exportizer Enterprise 8\exptizer.exe" /export /ExportType=DATABASE /ExportMode=REPLACE+INSERT /IncludeMemo /SrcDBInterface=ado /SrcDBKind=FILE /SrcDBDriver=Excel /SrcDB=C:\TEST\employee.xlsx "/SrcTableName=BONUSES$" /TrgDBInterface=fd /TrgDBKind=FILE /TrgDBDriver=Firebird /TrgDbUserName=sysdba /TrgDbPassword=masterkey /TrgDB=C:\Test\employee.fdb /TrgTableName=BONUSES

The same as above, but in silent mode and using a log file:

"C:\Program Files (x86)\Vitaliy Levchenko\Exportizer Enterprise 8\exptizer.exe" /silent /export /ExportType=DATABASE /ExportMode=REPLACE+INSERT /IncludeMemo /SrcDBInterface=ado /SrcDBKind=FILE /SrcDBDriver=Excel /SrcDB=C:\TEST\employee.xlsx "/SrcTableName=BONUSES$" /TrgDBInterface=fd /TrgDBKind=FILE /TrgDBDriver=Firebird /TrgDbUserName=sysdba /TrgDbPassword=masterkey /TrgDB=C:\Test\employee.fdb /TrgTableName=BONUSES /LogFile=C:\Test\export.log

Exporting all tables from Excel file to existing Firebird database in silent mode:

"C:\Program Files (x86)\Vitaliy Levchenko\Exportizer Enterprise 8\exptizer.exe" /silent /export /ExportType=DATABASE /ExportMode=REPLACE+INSERT /IncludeMemo /SrcDBInterface=ado /SrcDBKind=FILE /SrcDBDriver=Excel /SrcDB=C:\TEST\employee.xlsx /SrcTableName=* /TrgDBInterface=fd /TrgDBKind=FILE /TrgDBDriver=Firebird /TrgDbUserName=sysdba /TrgDbPassword=masterkey /TrgDB=C:\Test\employee.fdb /TrgTableName=* /LogFile=C:\Test\export.log

Alternative Scenario Using Third-Party SQL Tool

If you have a third party Firebird SQL tool, you can export the Excel data in Exportizer to a SQL script first, and then load data from the script using that tool.

But please note, that when choosing exporting to SQL, your export process will have two phases: first, exporting the data to SQL script; second, loading data from the script to your target database. So, this way can be less effective, especially for large datasets or when automating the data exporting.

We recommend to try both export scenarios and select the one, which is fastest and more convenient for you.

Exporting Range of Cells Using Clipboard

  1. Copy a range of cells in Excel.
  2. Launch Exportizer.
  3. Register your Firebird database.
  4. Open your registered Firebird database and a target table in it.
  5. Rearrange the table columns so that their order match the order of Excel columns from the copied range.
  6. If you want to insert the copied data as new records, click Insert Record button. Skip this step, if you wish to update existing data.
  7. Right-click the cell, which will be the first cell to paste data to, and choose Paste Cells from Clipboard menu.

See also

 Opening Microsoft Excel Workbooks (.xls)

 Opening Microsoft Excel 2007+ Workbooks (.xlsx, .xlsb, .xlsm)

 Opening Firebird Databases

 Command Line Usage