update P_Dic_Region set F_Long=a.F_Long,F_Lat=a.F_Latfrom(select * from OPENDATASOURCE( 'Microsoft.Ace.OleDb.12.0', 'Extended Properties="Excel 12.0;HDR=YES;IMEX=1";Data Source="D:\Region.xlsx"' )...[a$])a where P_Dic_Region.F_Code=a.F_Code
本文共 379 字，大约阅读时间需要 1 分钟。
update P_Dic_Region set F_Long=a.F_Long,F_Lat=a.F_Latfrom(select * from OPENDATASOURCE( 'Microsoft.Ace.OleDb.12.0', 'Extended Properties="Excel 12.0;HDR=YES;IMEX=1";Data Source="D:\Region.xlsx"' )...[a$])a where P_Dic_Region.F_Code=a.F_Code
转载于:https://www.cnblogs.com/niuniu1985/p/7451851.html