I am wondering if there is a way to import a spreadsheet with multiple tabs
of data.

I have a spreadsheet that has multiple tabs breaking data down into their
separate months. Every tab has the same column structure. I am wanting to
convert this into a single Access table so that I can easily report off of
it. I will have to import this spreadsheet every month because the creator of
the spreadsheet refuses to use Access and can't be made to do it.

I am needing a method to get each tab's data and put it into a table of my
choice.

I have been looking at the doCmd.TransferSpreadsheet command and it seems to
only want to import the 1st tab.


Thanks in advance

The first thing that should be clarified is that what you call a "tab" is
actually a worksheet. And a collection of worksheets is a workbook. Once
you clear that up, you can take a look at how you want to transfer the info
from one workbook to the other.

"Gsurfdude" wrote:

I am wondering if there is a way to import a spreadsheet with multiple tabs
of data.

I have a spreadsheet that has multiple tabs breaking data down into their
separate months. Every tab has the same column structure. I am wanting to
convert this into a single Access table so that I can easily report off of
it. I will have to import this spreadsheet every month because the creator of
the spreadsheet refuses to use Access and can't be made to do it.

I am needing a method to get each tab's data and put it into a table of my
choice.

I have been looking at the doCmd.TransferSpreadsheet command and it seems to
only want to import the 1st tab.


Thanks in advance