table to excel

423
4
01-12-2018 02:43 AM
FelixBuchinger
New Contributor II

Hello,

is there a possibility to export different tables to the same excel-file?

with the tool "table to excel" the excel-file is overwriten when you try to export a different table into the same excel-file. Is there a possibility to save the new table in a new sheet of the same table?

Regards

Felix

Tags (1)
0 Kudos
4 Replies
AbdullahAnter
Occasional Contributor III
0 Kudos
TedKowal
Occasional Contributor III

If you are using any database other than a GDB, you can open up MS Access, connect to the tables you wish and export easily to one excel file from any number of tables or views.....

Vote here to keep this extremely flexible and useful tool !

 Enable ArcGIS Pro to access ESRI Personal Geodatabases

0 Kudos
XanderBakker
Esri Esteemed Contributor

With the standard tools available you will create a sheet in a Excel file and you won't be able to do this. If you have knowlegde of Python you can do this. See for instance: python - creating multiple excel worksheets using data in a pandas dataframe - Stack Overflow 

0 Kudos
FelixBuchinger
New Contributor II

Thank you for your help, i will see if i can use one of these things.

0 Kudos