Excel into SQL from folder

[spoudyal2]

Hello all,

I currently have a folder with Excel sheets. The main folder has multiple sub folders designated for different purposes and all of them have excel sheets added each month (for eg. this month I added in new excel sheets to all those folders names 24-06-30, end of last month), and this would happen every month.

Currently we have Access set up with VBA so it reads all the data from respective folders, cleans it and stores it into respective data table. We are looking to switching to SQL entirely and not use Access (at all!).

Now my main concern is somehow having SQL to read the Excel sheets (taking into account the name changes every month but it will always be the last day of last month) from the folders and updating the datatables. (P.S. I can't use VS to create SSIS packages because of company/budget restrictions.) How do I automate this process?

[Anonymous]

Hi @spoudyal2 ,

Based on your description, I would like to confirm with you where the data source for the excel sheet is stored (local or cloud). Because different storage location corresponds to different solution.

Best Regards,
Adamk Kong