Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite

Does anyone know how to export a shape file out of ArcGIS into an Access 2007 database?

share|improve this question
Are you referring to an *.accdb vs a *.mdb? – RyanDalton Jun 14 '12 at 16:47

3 Answers

up vote 2 down vote

This should give you the understanding on how you should go about.

http://wagda.lib.washington.edu/gishelp/tutorial/AccessImportShp.pdf

I know the text is not helpful but the images should help you through.

Basically, what the pdf is explaining, is that you can export the shapefile to a PersonalGeodatabase (which you will have to create before hand) and save it in a .mdb format. .mdb is a MSAccess recognizable format which is something that you can see when you open the particular file in MsAccess (As shown in the pdf in the link).

Personally, I would not recommend exporting the file to MSAccess or Personal Geodatabase. There are lot of flaws related to it. I would recommend that you export the data to FileGeodatabase.

share|improve this answer
Great - thanks for the information. If you recommend FileGeodatabase - I will look into that program for sure. – user8216 Jun 14 '12 at 16:46
I wouldn't recommend a file geodatabase if you want to connect to it via Access - it just doesn't work – Ian Jun 15 '12 at 0:50
up vote 1 down vote

The official way that ESRI suggest you create a link to an Access 2007 (accdb) database is discussed here.

Great - Thank you :)

share|improve this answer
up vote 0 down vote

You can use the "Table to Table" tool to convert a Shapefile .dbf into an MDB table.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.