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