--- In firebird-support@yahoogroups.com, "zamb1zz1" <spam@s...> wrote:

>
> What's the best way to import CSV data? Does a free/OSS tool exist
> for this? If no, one w/ a trial period?
>
> Does FB do this natively?
>
> Thanks!

I would be very surprised if you couldn't find one. I have come across
this problem twice before, but as the raw data required some
processing into the correct format, it may have been stretching the
limits of such a program.

The first way I tried was reading the CSV file into a delphi program,
parsing it as required, then running SQL commands from it. It is a
very rough way of doing things, but again, it was a once off thing
where a fair bit of processing was needed.

The second way I tried was to use excel. Open the CSV file in excel,
then create a formula that results in the appropriate insert string
being generated for each line. Then copy and paste special -> values
only. If it is a once off, that may be adequate for you.

Other ways I have thought of but never tested, involve opening the
file in excel and saving it as a dbf file, setting a BDE alias and
running a datapump into your new firebird database.