Link to home
Start Free TrialLog in
Avatar of ctownsen80
ctownsen80Flag for Afghanistan

asked on

Import All Tabs from an Excel Sheet into access AND the tab name

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
Any takers?
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial