> Then from Delphi, loop through all 57,000,000 records,
> setting the Parameters, and doing the insert from the
> TIB_Query?

Dont use TIB_Query for imports/exports. Use TIB_Cursor or TIB_DSQL.

> This seams to be a monumental PITA.... I wanted to
> do this more as a utility, rather then having to do it
> manually, I guess I could do somthing like a tab
> delimited format. Think others might be interested
> in a small utility that does this? Given an existing
> table, a list of "fields" in the first row, then the
> data in the remaining rows.

Is there some reason you dont like the TIB_Export and TIB_Import
components? If so check out the various "pump" utilities that are
available around the place.

Another option is to remember that FB is free. About the only reasons
for using an external format now is to transfer to/from other formats
or non FB/IB users, otherwise just transfer from gdb to gdb using the
datapump. Just a thought.


Geoff Worboys
Telesis Computing