Subject Re: [ib-support] importing lots of rows
Author Claudio Valderrama C.
"Raphael Bauduin" <raphael.bauduin@...> wrote in message
news:20020409134038.GD4974@raphael...
> Hi,
>
> > Similar...but not identical - but if you can export your data in fixed
> > format, you can define the output file inside the database as an
external
> > table.
>
> I export the data in this format:
>
> field1|field2|field3|field4|field5|

If you can't change the format, you can define dummy fields of one CHAR in
the external table to skip them. And you have to define a final dummy field
for the record of one or two CHAR's, depending on whether your file is LF or
CRLF terminated.
There's a program that supposedly dumps records in the examples directory,
but it's totally outdated and has not been touched for years. You better
look at other utilities if you don't want to define external tables.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing