Re: Importing dBase III files
Posted in 1997
In <5s3t38$jnt@cssun.mathcs.emory.edu> billy@west.co.za ("Billy Wheeler") writes:
>On 2 Aug 97 at 18:43, Francois McDonald wrote:
>> Does anybody know of an easy way to import dBASE III files into
>> Informix 7.22 ?
>Not really. You'd have to export or dump the dBase files as a CSV
>(comma separated value) file, then use either dbaccess's LOAD
>statement or the dbload command to load the data.
Perl Modules are your friend. :)
You should be able to use Xbase.pm to access the DBF files, and the
Informix DBD to update the Informix database.
Xbase.pm
http://www.perl.com/CPAN/modules/by-module/Xbase
This is a module for perl 5 that allows easy xbase like access to xbase DBF
files and Foxpro IDX (index) and FPT (memo) files.
DBD-Informix
http://www.perl.com/CPAN/modules/by-module/DBD/
--
Clay Irving <clay@panix.com> http://www.panix.com/~clay/