Thread: Data Conversion

Data Conversion

From
"Mahesh Guleria"
Date:
Can be convert data from postgres to foxpro2.5??
Is it possible?? Please help me.

-MG

Re: Data Conversion

From
Christof Glaser
Date:
On Monday, 25. June 2001 08:20, Mahesh Guleria wrote:
> Can be convert data from postgres to foxpro2.5??
> Is it possible?? Please help me.

I did it once, a year ago:

 - import the data into MS Access
 - export the data from Access as text delimited (and choose a
   delimiter that doesn't occur in your data)
 - run a perl or sed script to change anything that needs to be changed
   (like date values or field order)
 - create the table schema in PostgreSQL
 - import the text files using psql and the COPY FROM command

There might be an easier way by accessing Postgres directly from Access
through ODBC. It might be slower, though :->

Hope that helps a bit.

Christof
--
          gl.aser . software engineering . internet service
       http://gl.aser.de/  . Planckstraße 7 . D-39104 Magdeburg
Tel. +49.391.7 44 77 10 . Fax +49.391.7 44 77 13 . Mobil 0177.77 92 84 3

Re: Data Conversion

From
"Andrew W. Nosenko"
Date:
Mahesh Guleria wrote:
: Can be convert data from postgres to foxpro2.5??
: Is it possible?? Please help me.
:

Perl5 + DBI + DBD::Pg + DBD::XBase

--
Andrew W. Nosenko    (awn@bcs.zp.ua)