Subject Re: [firebird-support] Looking for library to create external tables without FB
Author Martijn Tonies
Hello Maxim,

> I'm looking for a tool to bulk load from DBFs. Probably via external
> table. Simple way of reading DBF and executing INSERT's takes 30 min
> for 1mln records. Copy of 1 mln inside FB between two tables takes 5
> min for 1 mln records.
> I'm thinking about some tool to create FB external table from DBF.

You do know that an "external table" in Firebird is a plain text file,

If so, you can just read the DBF table and create plain text from it in
a small application, then use Firebird to transfer the data between the
external table and an internal table.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!