How to export geodatabase to MS Excel or Access?

3186
8
Jump to solution
03-09-2020 05:23 PM
MereKelly
New Contributor II

I had a fairly simple geodatabase sent to me. I am not able to see the file's full contents unless I open it in Arc GIS Pro. The easiest way for me to run computations with it would be to export to Excel or Access. The only export tool I send to find involves export the metadata to xml. That is not what I need. Is there a way to do this?

0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Esteemed Contributor
8 Replies
DanPatterson_Retired
MVP Esteemed Contributor
MereKelly
New Contributor II

Thank you, this is great! Is there something similar for Access?

0 Kudos
DanPatterson_Retired
MVP Esteemed Contributor

Access isn't supported in Pro or Map, you will have to do that elsewhere

0 Kudos
HamedFarzin
Esri Contributor

Mere Kelly‌ You can use both ArcGIS Pro and Arc map to do this: Please use instruction in the links below: 

ArcGIS Pro:  Export tables—ArcGIS Pro | Documentation 

ArcMap: How To: Export an attribute table from ArcMap to Microsoft Excel 

Hope this helps! 

RobertBorchert
Frequent Contributor III

Create a personal geodatabase.

Copy all the features from file geodatabase to the personal.

A Personal Geodatabase is a MS Access Database

0 Kudos
MereKelly
New Contributor II

Hello, thanks for replying. What command (or series of commands) can I use in Arc GIS Pro to do that? I don't see that as an export option for tables.

0 Kudos
DanPatterson_Retired
MVP Esteemed Contributor

Table To Table—Conversion toolbox | Documentation 

but dbf, csv or txt are the output options

and from here

Frequently asked questions—ArcGIS Pro | Documentation 

Can I use personal geodatabases (.mdb) as data sources for ArcGIS Pro?

No. Personal geodatabases are not supported in ArcGIS Pro, so you cannot use personal geodatabase datasets as inputs for geoprocessing tools or create those datasets as outputs. File geodatabases are fully supported and are the default workspaces for ArcGIS Pro projects.

0 Kudos
RobertBorchert
Frequent Contributor III

Personal Geodatabase are not recognized by Pro. You would have to use ArcCatalog.

You can also right click on any feature in pro and select

Data >  Export Tables

0 Kudos