Importing multiple worksheets from the same Excel workbook

  • Thread starter Thread starter Jasonm
  • Start date Start date
J

Jasonm

Hi all, I searched for an answer to this question, but didn't find a direct
answer. I have an excel workbook that has many worksheets and I need to
import all of the data into one access table. I have tried creating a range
from the selection, but that range is not visible from the import wizard!

Is this possible? Do I need to cut and past all of my data into concurrent
rows?

Thanks, Jasonm
 
Range argument can be the name of a worksheet in the file:
"WorksheetName!"

If there is a space or non-letter or non-number character in the worksheet
name, then
"'WorksheetName'!"
 
I could get it to work with a single worksheet, but I wanted to catch ALL
worksheets in the workbook (there were about 72!) it apears that access
cannot retrieve the data in this way (at least I conld not work around it...
So I took a bacwards approach and wrote VBA that would copy text from each
worksheet and paste it sequentially into a new worksheet. I then imported
only that worksheet...

Thanks very much for the input.

Jason
 
Back
Top