importing of 1000 excel

[#1]

    Dear All,

I have almost 900 excel and in stage one I have to add all of them one by one but its not easy to import 900 times...

So is there are any way to import all excel in 1 or 2 steps

Rahul

[Anonymous]

Hi,

put all the files in the same folder.make sure that all of them have similar name with a small difference to identify the file.

say file1.xls,file2.xls so..on

FOR a=1 to 9

LOAD * FROM file$(a).xls;

NEXT

HTH

Ravi N.

[MarcoWedel]

LOAD * FROM filename*.xls

you can use wildcards in the filename to load all matching files.

just load one file with the import wizard and change the filename in the resulting script using wildcards.

[MayilVahanan]

Hi

Please refer

import all excel sheets

or

Load multiple excel files from Multiple excel sheetsinto QV