How to pull multiple sheets from one Excel File

[#1]

Hello,

How do you pull in multiple sheets from one excel file when the sheet's are renamed? I know if you have the Sheet's named Sheet1, Sheet 2, etc then you can do  something like this. What if you rename the sheets to 2012, 2011, etc? What is the easiest way to import all sheets?

for loop=1 to 5
LOAD

Date,
First,
Last

(ooxml, embedded labels, table is Sheet$(loop));

NEXT;

[mazacini]

Hi

What if you named each sheet in your "for" statement:

for each vSheet in '2011','2012'

and then

table is $(vSheet)

Joe

[Anonymous]

Here is an example I uiploaded recently here answering a similar question.  Except, there were multiple files with different number of sheets.

Regards,

Michael