[postgis-users] about MS ACCESS y PostgreSQL

[Obe, Regina]

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.