Re: Importing a dbf file into informix

Posted in 1996

sinyem@pc.jaring.my — 4 Dec 1996 12:43:31 -0500 — source: Informix-list mailing list archive (1991-1998)

On Mon, 02 Dec 1996, olszowy@worldnet.fr (Z6PO) wrote: >I'm trying to import a dbf file into an informix database. I try to >use the dbImport program but without any success. > >Is there someone who have tried (and succeed !) this job ? >Or is there any doc on line ? > Are you refering to dBASE data file ? if so, see below: 1. use the dbExport facility to dump your data to flat file with a delimiter of '|'. You may also use the fixed length method. 2. transfer or upload the flat file to your informix database server 3. LOAD the flat file to the required table. Note: this is assuming that the dbf file structure (in term of number of fields) is the same as that of informix table. Good luck. >Thanks ! > >Jean-Philippe Olszowy. > > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= _/_/_/_/ _/ _/ _/_/_/ Richard Wellis Sinyem _/ _/ _/ _/ _/ Company: Microlink Consultancy Sdn Bhd _/ _/ _/ _/ _/ Tel: 082-415785 Fax: 082-428264 _/ _/ _/ _/ _/ _/_/_/_/ _/ _/ _/_/_/ E-Mail: sinyem@pc.jaring.my (home) _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/_/_/_/_/ _/_/_/ URL: http://www.microln.com.my =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=