I have the managers in different cities update an excel sheet, they send me the sheets daily, and I have to update my SQL database.
Is there a way they can use the excel sheet, link it to my server (ODBC or any other method), that they can update the Excel changes done to my SQL SERVER.
Please see attached what I have in mind.
My update code in SQL is simple.
Update Activeorders set WaybillNumber = test.Code where ActiveOrders.Orderno = test.OrderNo
Your help is appreciated.