Hi Mark,

> I have a file of several million records in csv style format. Is there a
> utility or api that will let me load these efficiently? By efficiently I
> mean faster than reading the file and calling EXEC SQL INSERT for each
> record.....

Use prepared statements - that's a lot faster.

If you like, you can try Database Workbench and the CSV import -
see www.upscene.com for a trial download.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com