How to upload an Excel or CSV file to Firebird?

Question

I am using Firebird and I need to load an Excel file into a database table. I need a tool that does this well. I tried some of them found on Google, but all of them have some errors.

Since the Excel data was not created by me, it would be nice if he could scan the file and find out what data is inside, and suggest a table that will be created in the database.

It would also be nice if I could compare the file with the data that is already in the database table, and I can choose which data to load and which not.

The tools that download CSV files are also great, I can "Save As" CSV from Excel before downloading.

Answer 1

Well, if you can use CSV, I think XMLWizard is the right tool for you. It can load a CSV file and compare with database data. And you can select the changes you want to make to the table.

Don't let the name fool you, it works with XML, but it also works great with CSV files. And it can also evaluate column data types and suggest a CREATE TABLE statement for your file.

Answer 2

Have you tried FSQL ?

This freeware is very similar to the standard ISQL Firebird, but with some additional features such as importing data from CSV files.

I used it with DBF files and it worked fine.

Answer 3

There is also an EMS data import tool for Firebird and Interbase http://www.sqlmanager.net/en/products/ibfb/dataimport

It is not free, but it accepts a wide variety of formats, including CSV and Excel.

EDIT

Another similar payment tool is the FireWird Data Wizard http://www.sqlmaestro.com/products/firebird/datawizard/

Answer 4

There are several online tools that can help you generate DDL / DML scripts from the csv header / sample dump file, check out: http://www.convertcsv.com/csv-to-sql.htm Then you can use sql-workbench Data Pumper or WbImport Tool from the command line. Orbada has a graphical interface that also supports importing a csv file. DBeaver Free version also supports importing csv from the box.