I can do an export with the dbf components to an textfile so that will be no
problem.

- Using the create table to an external file looks like using an xml file as
table....
- removing the index is a good idea
- So I don't need any IBO component...

I have the idea I was doing this 10 year ago also for importing data to get
it into dbf/dbase. Not much changed over the years...


Bram van der Voet / A&V Automatisering
bram@... <mailto:bram@...>
Glasbergenlaan 6
2235 BP VALKENBURG ZH
tel 071 407 6956
fax 071 407 3939


-----Oorspronkelijk bericht-----
Van: Clément Doss [mailto:cdoss@...]
Verzonden: zaterdag 2 december 2000 14:07
Aan: IBObjects@egroups.com
Onderwerp: [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
> _______________________________________________________