The best way to use SSIS ETL tool which will read your excel data from any specified excel path and update your sql database table. You can schedule this ETL tool from sql job OR you can manually execute your package.
Let me know if you want to discuss further.
I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below:
Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4)
BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4)
Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3)
Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1)
My Technical background
• Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently.
• Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models
• Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas
• Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;