I have an excel file called "FileEE.xlsx". There are 3 sheets, but for this issue, the names of the sheets are irrelevant, because i want access to pull in the data from Each sheet and place each sheets into a seperate table. Additionally, i would like for each table to have a new field added that would identify the name of the Excel tab the data was exported from.
For this example, assume the sheet is located at C:/my documents/FileEE.xlsx.
Hopes this makes sense