Is want to know is there anyway to attain the name of a table or the name of a query when you are exporting from access to excel. I want to be able to display the name of the access table/query that the spreadsheet came from on a separate worksheet of the spreadsheet. This is needed b/c i export hundreds of files a month and should a problem occur with a report, i want to be able to look at the info that is stored on the second worksheet of the report and know what table of the database the spreadsheet was created from.
Thanks
Thanks