[postgis-users] HELP! Ms-Access shape data to the_geom of postgresql
computrain at paradise.net.nz
Mon Nov 13 00:35:05 PST 2006
I can't give you a full answer but I can tell you why (I think) the "data
conversion" is failing (somebody please correct me if I am wrong). I think
you will find that the co-ordinate data in Access is a "double" or "single"
data type as Access does not have a "geometry" data type like in Postgres.
When you use the PostGres ODBC connector you are just transferring the data
from one database to another so Postgres is just placing the data in the
fields in the nearest data type that is equivalant to the Acces data type.
If the data needs only to be transferred once (not on a regular basis) from
Access you could import the data by writing a small routine in C++.Net or
VB.Net. I wrote a small app a while ago that imported geometry data into
I connected to PostGres using NPGSQL data connector. All my data was in csv
fomat inside a text file. The routine opened the csv file and then imported
each record into Postgres by using an SQL insert statement combined with the
GeometryFromText() function which converts text coordinates into a geometry
data type in Postgres.
Having said that I am not competent with SQL so I suspect that you could
write an SQL statement within Postgres to import and convert data that
resides in a csv file.....this would mean exporting your data from Access
into a .txt or csv file.
Hope this gives you at least some help.
----- Original Message -----
From: "Hendra Yana" <Hendra at lskk.ee.itb.ac.id>
To: <postgis-users at postgis.refractions.net>
Sent: Monday, November 13, 2006 9:00 PM
Subject: [postgis-users] HELP! Ms-Access shape data to the_geom of
> I've been trying to convert database from Ms-Access shape data to the_geom
> for postgresql.
> I try to export from MS-Access to postgresql with PGSQL-ODBC connection,
> but the result in postgresql still not result as the_geom field but still
> the shape data in fields.
> Can anyone tell me how to Convert database from Ms-Access shape data to
> the_geom for postgresql???
> thanks for reply....
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.14.3/531 - Release Date: 12/11/2006
More information about the postgis-users