Re: DBF into Informix

In article <cltucker-2102971445570001@user-37kb9i8.dialup.mindspring.com>, cltucker@mindspring.com (Chris L. Tucker) says: >I'm trying to import a .dbf file into an Informix database. I >feel like the answer is staring me in the face somewhere, but >without writing some ugly perl scripts I can't seem to get it >into the database appropriately. I would have thought that the approach to take is to unload/convert the .dbf file into a delimited file and then to load this into Informix using a "load from 'filename' insert into tablename " SQL statement or similar. If the .dbf layout is not what you need in Informix then make up an Informix table that matches the structure of the .dbf file, load into that, and later select it into other tables as required. dbimport will only load stuff that has be dbexport'ed from an Informix database...it doesn't work too good on alien databases!!! :->