Sign up ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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
Welcome to gis.stackexchange! Please note that a good question on this site is expected to show some degree of research on your part, i.e. what you have tried and - if applicable - code so far. For more info, you can check our faq. – underdark Sep 4 at 17:15

3 Answers 3

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

share|improve this answer

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

share|improve this answer

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

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

Your Answer


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.