Is it possible in ArcMap 10, using the reporting tool, to connect a report to non-spatial data, like from Excel or Access tables?


If you add an Excel table to the ArcMap document before running the Report Wizard, that table is available to the Report Wizard (reporting tool).

The table doesn't need to be shown on the map, it just needs to be included in ArcMap's table of contents. To add it, click Add Data, navigate to then double-click the Excel file, and choose the appropriate table (worksheet) from the file.

| improve this answer | |
  • 1
    I'm not sure if this is always true, but occasionally I had to refresh the layer to get the latest data from excel – dassouki Jul 29 '11 at 12:51
  • Good point. I've seen similar issues where sometimes (but not always?) I've had to refresh with connections to external files. – user3461 Jul 29 '11 at 13:33
  • If you convert the EXCEL table to a Geodatabase Table that will always be available - but just not convenient... – Mapperz Jul 29 '11 at 14:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.