Hi guys,

for months now Ive been importing MS Access tables (x 4) into interbase
using datapump. I now have the ability to get the same data in delimited
text.

What is the best way to pump delimited text data into IB6.01???

Thanks,

Andy

The best would be if you could get the data in fixed length ASCII format and
use an InterBase external table for the import. I can't tell you what the
best (I assume you mean fastest) method is for importing delimited text but
can use the DataPump.

--
Bill

No its definately delimited, with an asterix. (*)

If I can find a way of doing this it stops me having to put the files into
MS Access and then using datapump to put them into IB. There are four tables
of about 1.7 million records each.

I cant seem to get a driver to work with delimited text for the BDE then i
would use datapump

Any ideas??

Have you tried using the BDE ASCII driver? You can set the delimiter and
separator in the schema file to meet your needs. See
http://community.borland.com/article/0,1410,15892,00.html.

--
Bill

Ahhh well this is my problem.
My bde came with Delphi 4 enterprise and it doesnt appear to have the ASCII
text driver.

Any idea how to get it?

thanks,

Andy

_Every_ version of the BDE that I have used has had the ASCII text driver.
What makes you think you don't have it?

--
Bill

See reply in borland.public.bde

Thanks.