[postgis-users] about MS ACCESS y PostgreSQL
Obe, Regina
robe.dnd at cityofboston.gov
Tue Jul 1 06:41:06 PDT 2008
You can also do this with ogr2ogr - http://fwtools.maptools.org/
If you have a personal geo database format and you are on windows, then you can just specify the file path to the mdb something of the form
ogr2ogr -append -f "PostgreSQL" PG:"host=pghost user=pgloginname dbname=pgdbname password=pgpassword port=5432"
c:\myaccess.mdb table1 table2 table3 ...
If you have regular old access database, then you have to create a system odbc connection and do something like
ogr2ogr -append -f "PostgreSQL" PG:"host=pghost user=pgloginname dbname=pgdbname password=pgpassword port=5432"
ODBC:"someaccessdsn" table1 table2 table3 ...
Where table1, table2, table3 are the names of the access tables/geo database featureclasses you want to export.
If you want to export all tables or feature classes then just don't specify any table names.
Ogr can export all tables or set where as the MSAccess export requires exporting one at a time. Also ogr knows how to
deal with ESRI's access personal geodatabase format which regular Access will just present as a set of meta tables not easy to export with the Access export feature.
Hope that helps,
Regina
________________________________
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Burgholzer,Robert
Sent: Monday, June 30, 2008 11:21 AM
To: Francisco; PostGIS Users Discussion
Subject: RE: [postgis-users] about MS ACCESS y PostgreSQL
ODBC connections will do the trick. If you have the PostgreSQL ODBC driver (downloadable from the web somewhere) you can configure a data source on your windows system, then use the "Export" function in MSAccess to export the tables into your postgresql datasource.
Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
rwburgholzer at deq.virginia.gov
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Francisco
Sent: Monday, June 30, 2008 12:00 PM
To: PostGIS Users Discussion
Subject: [postgis-users] about MS ACCESS y PostgreSQL
Hi,
it Possible to pass of MS ACCESS to PostgreeSQL?
exist some application for this?
thanks Francisco
___________________________________
Este mensaje esta libre de virus.
Revisado por Kaspersky Antivirus
Engine version: 4.0.1.14 Engine date: 2002/06/25 Definition count: 783403 Definition date: 2008/06/22 MDAV version: 2.2.9
Dpto de Sistemas Informáticos
Oficina Central Grupo Empresarial GEOCUBA
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
More information about the postgis-users
mailing list