How import data from multi-tab Excel file
Posted on 2014-11-18
I have a multi-tab (worksheet) Excel file. The file has 79 worksheets total. Each worksheet has the exact same headers, and they are all named exactly the same. I could manually import or append all 79 of them into one table but that would take a long time.
What I really want to do is click a command button on a form that will loop through all of the worksheets in the Excel file AFTER is allows me to navigate to the Excel file, and import the data into a single table.
Is this even possible? If so I have no idea how to begin writing the code.