Each great god! Help: after importing the EXCEL table in SQL, EXCEL table update, how SQL tables in the synchronous update? Similar to how is the function of the access in the link table in SQL implementation? Online, etc., be urgent!!!!!!

CodePudding user response:

Can only write programs, regularly check whether want to change the:
https://docs.microsoft.com/zh-cn/dotnet/api/system.io.filesystemwatcher? Redirectedfrom=MSDN& View=netframework 4.8
If there are changes, immediately to the excel data update to the SQL server,
https://blog.csdn.net/yenange/article/details/77164587

As for you said "update", small table ok, table big difficult,