Thank you.

Of course I know that it's a text. But it's not that simple taking
into account data formats (for numbers, dates, strings with
different encodings including UTF). I'm just looking for a bit
simpler way to work with this format. Ideally it should be a Delphi
dataset.

Don't you know about one?

Maxim.

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> 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,

> right?
>
> 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
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>