Upload multiple excel files from local pc directory
In our requirement, There are almost 20 excel files in a directory of local pc. At run time, we will not be knowing the file names of these excel files but the columns of these excel files are same and known to us.Also path of the directory is with us.
We need to upload all these excel file into variuos internal tables for BDC Processing at later stage. Can anybody suggest how to accomplish this?