| Subject | Re: [firebird-support] importing text file into Interbase |
|---|---|
| Author | Martijn Tonies |
| Post date | 2003-09-16T13:17:26Z |
Hi Geoff,
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
http://www.upscene.com
> What is the best way to import a CSV file into interbase? I amNo, there's no command for that.
> 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)
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
http://www.upscene.com