Greetings Geoff,

If you don't mind spending a little money, the check out SMImport Suite.

They have an TSMImportFromText component I use and will allow you to import
from any type of text file, fixed of delimited. The suite also allows you
to import form any other format as well and if you want to use, it comes
with a wizard component too.

Check it out at http://www.scalabium.com/ only $50.00 with source.

Well worth the money to save you time.

Mike

----- Original Message -----
From: "Geoff Rees" <reescom@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, September 16, 2003 8:10 AM
Subject: [firebird-support] importing text file into Interbase


> Hi,
> 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)
>
> Thanks for any help
> Geoff
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>