Subject Re: [ib-support] Help to Import CSV file
Author Martijn Tonies
Hi David,

> I'm new to Firebird.
> I have got the server (Win32 v1.0.2) up and running and have created
> some data bases, views etc. I now would like to import some exsiting
> data thats in CSV format into my newly created data bases. Some of
> these CSV files are large (500,000+ records 60 fields). What is the
> best way to import large CSV files.

1. Create a query:

INSERT INTO yourtable (col1, col2, col3)
VALUES (:col1, :col2, :col3)

2. Prepare it.

3. Assign parameters and call the Execute method.

Repeat step 3 for each line in the CSV file.

I believe IBO ( ) also has a component
that can do this.

Or use the CSV export in Database Workbench :)

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."