topic Re: How to export geodatabase to MS Excel or Access? in Data Management Questions

How to export geodatabase to MS Excel or Access?

MereKelly — Tue, 10 Mar 2020 00:23:04 GMT

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?

Re: How to export geodatabase to MS Excel or Access?

DanPatterson_Retired — Tue, 10 Mar 2020 00:31:34 GMT

Table To Excel—Conversion toolbox | Documentation

will do it

Re: How to export geodatabase to MS Excel or Access?

MereKelly — Tue, 10 Mar 2020 00:36:49 GMT

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

Re: How to export geodatabase to MS Excel or Access?

DanPatterson_Retired — Tue, 10 Mar 2020 00:41:46 GMT

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

Re: How to export geodatabase to MS Excel or Access?

HamedFarzin — Tue, 10 Mar 2020 00:44:38 GMT

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!

Re: How to export geodatabase to MS Excel or Access?

RobertBorchert — Tue, 10 Mar 2020 12:20:13 GMT

Create a personal geodatabase.

Copy all the features from file geodatabase to the personal.

A Personal Geodatabase is a MS Access Database

Re: How to export geodatabase to MS Excel or Access?

MereKelly — Tue, 10 Mar 2020 12:55:14 GMT

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.

Re: How to export geodatabase to MS Excel or Access?

DanPatterson_Retired — Tue, 10 Mar 2020 13:54:47 GMT

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.

Re: How to export geodatabase to MS Excel or Access?

RobertBorchert — Tue, 10 Mar 2020 14:00:19 GMT

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