I have a folder in a directory that is filled with 28-30 Excel documents each month. All Excel documents have the same schema. The names of Excel documents are different. My assignment is to open a folder grab one by one Excel documents, strip headers and load data into SQL table.
How to automate the process to get Excel documents from the folder and load data into SQL? Your help would be greatly appreciated.