<div>
<div class="content wysiwyg-content">
I have an excel file called &quot;FileEE.xlsx&quot;. 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. &nbsp;<br />
<br />
For this example, assume the sheet is located at C:/my documents/FileEE.xlsx.<br />
<br />
Hopes this makes sense<br />
Any takers?
</div>
</div>


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?

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,