[postgis-users] HELP! Ms-Access shape data to the_geom of postgresql

[P Kishor]

coordinate data in Access (equivalent to the geom in PostGIS) is
stored as a blob.

On 11/13/06, Marc Angelo <computrain at paradise.net.nz> wrote:
> 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
> Postgres.
> 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.
>
> Cheers
> Marc
>
>
> ----- 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
> postgresql
>
>
> > Help....
> >
> > 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
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> > --
> > 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
> >
> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/
-------------------------------------------------------------------------------------------------------
collaborate, communicate, compete
====================================================