Re: [SL] CSV files and importing

[Dr E. L. <el...@li...>]

http://dbf.berlios.de has/had a nice little program that translates DBF
files into PostgreSQL tables directly. One could then do a SELECT INTO
perhaps?

el


on 1/4/07 7:07 PM Jerome J. Auza said the following:
> Hi Jeff,
> 
> Some time ago, I had to deal with .DBF files and I used the Perl modules 
> in this link:  http://search.cpan.org/search?query=DBF&mode=all
> 
> There are more than one option so just try which one fits your need.  
> You might have to write a short script to do this.
> 
> jerome
> 
> Jeff Roberts wrote:
> 
>> Hello People
>>
>> My name is Jeff and I've been playing with SQL-Ledger for a few years 
>> but have decided this year I'd get it fully running in my business 
>> (electronic repair). I've got it installed on a server running BSD 5.3 
>> with PgSql 7.4.5 and Apache 2.0, everything seems to be running OK and 
>> I've already entered all of my GL accounts in.
>>
>> My next step is to import my customers, vendors and inventory 
>> items(services).
>>
>> I downloaded the import script but it says that I must have my data in 
>> tab delineated fixed length format and I'm having trouble finding a 
>> program that will save in fixed length format. My current data is in 
>> .DBF format and I've tried Paradox and Star Office 6.0 but neither gives 
>> an option to save in a fixed length. My workstation computers are Linux 
>> so a solution from EMS is out of the question, any suggestions?