Export Conditions

In most cases, to export from Microsoft 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. 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.

See also

 Opening Microsoft Excel Workbooks (.xls)

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

 Opening Firebird Databases

 Command Line Usage