hi

[#1]

i have 3 excel file data1, data2, and data3 in which there are 2 column EmpId and EmpName.

so how can i import data from these 3 file in a single load statement.......

[ashfaq_haseeb]

Hi,

Let say you have 3 files names as

File1.xls

File2.xls

File3.xls

Then try below

load *

From file*.xls;

Regards

ASHFAQ

[MayilVahanan]

Hi

Try like this

Load * from data*.xls;

or

for each i in 'YYY.xlsx', 'XXX.xlsx'

LOAD Student,

     field,

     Note

FROM

$(i)

(ooxml, embedded labels, table is Feuil1);

Next

[#4]

What type of file you have?