Discussion Locked

Using Dbase DBI with Perl5

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to read in a file and create a Dbase .dbf file. I currently do this by
opening file, then separate fields using the 'split' command. Using SQL commands I then parse the record, do a $csv-> fields command and then do an execute to write to the .dbf file. This is a very, very slow process. I am seeking a way to write the file to Dbase much more efficiently, preferably using some sort of native Dbase commands.

4 replies

by mark.thomson

Is there any reason why you can't use excel? If the file is a csv file, open the file, ensure that the field names in row 1 are correct and then save as a dbf file (there is a choice of vIII,vIV or v5) then quit, job done.

by rschroeter

I have to be able to transfer the data from a flat file to a database, preferably dbase. The method I currently use is just too slow and inefficient.

This discussion is closed to new replies.