[OSM-talk] OSM -> MS Access

Robert (Jamie) Munro rjmunro at arjam.net
Fri Jul 18 15:34:33 BST 2008


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Juan Lucas Dominguez Rubio wrote:
| Perhaps OSM --> CSV, then open it with Ms Excel as a spreadsheet then
| import from Ms Access ?
|
| http://svn.openstreetmap.org/applications/utils/export/osm2csv/

Why use Excel? Access has perfectly good CSV import built in.

I don't know what osm2csv does. It may be better to adapt osm2pgsql or
osmosis to talk to access instead of postgres or mysql.

I would expect that if you wanted to import the whole planet into
Access, it would struggle, which is why linking to tables stored in
MySQL or Postgres, as others have suggested, would probably be a better
idea.

What are you hoping to achieve?

Jamie

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkiAqfYACgkQz+aYVHdncI3XbQCeOTNDf0WF1sBpZ6yFmmku2r10
ouwAoMyRdNN3YpiZ+87xT/S+irJdqne2
=4/nB
-----END PGP SIGNATURE-----




More information about the talk mailing list