Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question
add comment

1 Answer

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.

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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