Load Multiple sheets in a single excel data source

[Anonymous]

Hi Friends,How to Load an Excel data source which is having multiple sheets in a single Excel data source.

All Regions Tab in data source has same set of data i.e., column names and Fields are same we can concatenate as a single Sheet and need help on these.

[MK_QSL]

Load multiple excel files from Multiple excel sheetsinto QV

Import multiple sheets in excel

Load multiple sheets and excel files

[#3]

Hai Swethasmilek

Rename the Four Sheets as A1,A2,A3,A4  then in script pane write the below code

FOR VCOUNT=1 TO 4

LOAD [Address Number],

     [Business Family],

     [Business Unit],

     Customer,

     [Customer Number],

     [Customer Type],

     Division,

     [Line of Business],

     Phone,

     [Region Code],

     [Regional Sales Mgr],

     [Search Type]

FROM

(ooxml, embedded labels, table is A$(VCOUNT));

NEXT

[Anonymous]

It was given by Business People it cant be renamed.other then renaming can you help on variables with loop