topic Re: table to excel in Data Management Questions

table to excel

FelixBuchinger — Fri, 12 Jan 2018 10:43:56 GMT

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

Re: table to excel

AbdullahAnter — Fri, 12 Jan 2018 12:29:33 GMT

Please read this this link: An overview of the Excel toolset—Help | ArcGIS Desktop

Re: table to excel

TedKowal — Fri, 12 Jan 2018 14:32:44 GMT

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

Re: table to excel

XanderBakker — Fri, 12 Jan 2018 14:33:57 GMT

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

Re: table to excel

FelixBuchinger — Fri, 12 Jan 2018 14:57:35 GMT

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