Subject Re: [firebird-support] importing text file into Interbase
Author Martijn Tonies
Hi Geoff,

> What is the best way to import a CSV file into interbase? I am
> creating the csv file from a table, then want to allow users to import
> the csv file into their copy of the database. The csv file has a header
> in the first record which matches the field structure of the table. Is
> there some command which will allow you to import the whole file in one
> go? (using Interbase 6.0.1 and Delphi 7 Pro)

No, there's no command for that.

I assume you're talking about files _on the client_ and not on the
server, right? 'Cause on the server, the best way would be to use
fixed-length ASCII files.

On the client, you need to create an INSERT statement, prepare
it, fill parameters and use execute per CSV line.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions