• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 756
  • Last Modified:

Importing a file into the database

I have an excel file that has an extensive list of entries in it. We also just got a program that uses Firebird as its database engine. We have a task of inputing the itmes in the database by the means of the program provided user interface. I was wondering if there is a way to import the excel data I have and if so what are the requirements. I understand there is field formatting requirements that the firebird has.
2 Solutions
Nick UpsonPrincipal Operations EngineerCommented:
firebird has external tables, which consist of a table definition and a file pointed to by that definition. The file MUST exist before you create the table.

The format of the file is fixed width fields. Usually the best plan is to define all fields as chars
of the appropiate length and then copy into a normal, non-external table with fields that are the correct types (int, char, float,m etc)

The documentation can be downloaded from here


and look for "external table"
The easiest way to import data from an other data source is to use the Datapump. The InterBase Datapump is a freeware downloadable from home/support page http://www.clevercomponents.com but I don't know whether is possible a direct import data from Excel. If not in this case you can use the Datapump tool of Delphi. To import data from Excel you have to use an ODBC driver. If you'd like to get some more help how to set the ODBC driver please contact us.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now