[OSM-talk] OSM -> MS Access

Juan Lucas Dominguez Rubio jldominguez at prodevelop.es
Fri Jul 18 15:39:09 BST 2008


You're right, you can connect directly to a text (csv) database too.
 
Lucas

________________________________

De: Robert (Jamie) Munro [mailto:rjmunro at arjam.net]
Enviado el: vie 18/07/2008 16:34
Para: Juan Lucas Dominguez Rubio; Talk Openstreetmap
Asunto: Re: [OSM-talk] OSM -> MS Access



-----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 <http://enigmail.mozdev.org/> 

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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20080718/55bc4426/attachment.html>


More information about the talk mailing list