I have need to export the data returned in my Access 2010 Web Database report into an Excel file format for processing by others in my organization. At this point I have not been able to figure out how to do this. Does anyone have any suggestions?
I have need to export the data returned in my Access 2010 Web Database report into an Excel file format for processing by others in my organization. At this point I have not been able to figure out how to do this. Does anyone have any suggestions?
Google: Access macro export to Excel
Does this help:
http://www.databasedev.co.uk/export-macro.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I had been looking at that, but I have not figured out how to get it to work in an Access 2010 Web Database. A web database acts differently than other Access Databases. The Macro builder does not have any 'Output_to' functionallity that I can see. Normal 2010 DB's have an Import/Export toolpack in the Actions Catalog. This is not present in a Web Database.