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.......
Let say you have 3 files names as
Then try below
Try like this
Load * from data*.xls;
for each i in 'YYY.xlsx', 'XXX.xlsx'
(ooxml, embedded labels, table is Feuil1);
What type of file you have?
Retrieving data ...