I tought, I could use the external files too.
I'm pumping from IB5.6 to IB6, but I think it would be faster than doing it
through the network. (read data, and send it back through the network).
Would it be faster than the IB_Datapump?

m.
________________________________________
Varró István,
mobra@..., http://mobra.16horse.org
SC WokaDat Soft SRL, Targu Mures, Romania
http://www.wokadat.ro
________________________________________

----- Original Message -----
From: "Clément Doss" <cdoss@...>
To: <IBObjects@egroups.com>
Sent: Saturday, December 02, 2000 15:06
Subject: [IBO] Re: Import dbf data


> Hi Bram,
>
> How fast can you create FixedLength ASCII files with your components?
>
> You could try to use
> CREATE TABLE TB_ZIPCODE EXTERNAL FILE 'C:\TEMP\ZIPCODE.TXT'
> (That means that you can SELECT * FROM TB_ZIPCODE and IB will read
> the info from a TXT file...
>
> To use external files, I believe they must be on the same machine
> as IB server. Then you can INSERT (with type casting) in a permanent
> table. (Remove your indexes before massing insertions.)
>
> This is the procedure I use to convert dBase or Paradox to IB.
> (this will not work if you have MEMOs and alikes... :-(
>
> Good Luck!
> Clément
>
>
> >
> > Helen, I never used Interbase 5. Dbf is the dbaseIII file format
> also used
> > in Foxpro. I have IBO alike components for fast access to the dbf
> file. I
> > was hoping to combine this with an IBO component to do a fast
> transfer.
> >
> > Bram
> > _______________________________________________________
>
>
>
>