I’m trying to create an automated process to append spreadsheets (xlsx) within a folder into an existing table in SQL server database.
For Example, in the folder currently there are three spreadsheets:
22 01 24 Budget Forecast.xlsx
22 01 31 Budget Forecast.xlsx
22 02 07 Budget Forecast.xlsx
Spreadsheet 1 and 2 are already manually uploaded into the database, however now I would like to setup a weekly schedule to upload only the latest spreadsheet (spreadsheet #3 in the example).
Hoping someone can shed a light on how to do this.