Re: [GNUe] Looking for a converter

[John Fabiani]

Kenneth D. Reiszner wrote:

>  
> John Fabiani wrote:
>
> > Hi,
> > I'm looking for a way to convert the table stru from a DBF  to Postgres
> > (to use with my gnue program).  Does anyone know of an easy way to get
> > this done.  Getting data into the table appears to be easy - but I have
> > to setup the table first. I tired to get pg2dbf working but was unable
> > to compile it for SUSE 9.0.  So I need a little help to ease the pain
> > moving from DBF to postgres.
> >  
>
> I am sure somebody else has a better solution  than this, but I would 
> find a machine with Microsoft Access 97/2000 (Might work on later 
> versions) and import the file(s). Then I would use one of the tools 
> that will covert the file to a sql file compatible with PostgreSQL. 
> The one that I have used is exportSQL version 3.2-dev 
> http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt . 
> <http://www.rot13.org/%7Edpavlin/projects/sql/exportSQL3.txt> This is 
> a text file that can be pasted into a blank MS Access module. The 
> output includes a file for creating the database, one for inputting 
> the data and a third for deleting the tables created if things go poorly.
>
> If your release of PostgreSQL (7.3 does) complains about creating the 
> tables with the date fields created by this tool do a search and 
> replace in a text editor to change them to something more viable. 
> Alternatively, and more elegantly alter the text file above. I have 
> converted about half of my files for my company to Postgresql with 
> this tool and I consider myself a real novice. Eventually I will move 
> everything over. MS Access imports data well but exports data only 
> grudgingly. With this tool its character is changed.
>
> Good luck,
>
> Kenneth D. Reiszner, Ph.D.
> President
> REAL, Inc. (Reiszner Environmental & Analytical Laboratories )
> P.O. Box 709,
> Lecompte, LA 71346
>
> Ph.No. & FAX: 318-443-0426
>
> > John
> >
> > _______________________________________________
> > Gnue mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/gnue
> ------------------------------------------------------------------------
>
> _______________________________________________
> Gnue mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/gnue
>  
Thanks - but I don't have access and if truth be known I don't want it.  
I do have visual foxpro and it has a few util's that can get the work 
done.  But I'm converting a lot of tables and it takes a long time to 
setup.  I was hoping someone had a simple tool to get it done.  I really 
thought it would be available (after all they say DBF is the most 
popular table stru on a PC). 
Again thanks.
John