Update the SQL database based on the contents of the Excel table

About the "Unable to create a linked server"(NULL)"This error may be reported when the OLE DB provider SQL Server 2008 reads Excel data: Unable to create linked server"(NULL)"The OLE DB Access interface"MSDASC"the instance. 1This error occurs primarily when reading data with code: INSERT into database table nameSelect* fromOpenDataSource ('microsoft.ace.oledb.12.0','Data source= "d:\Excel table name. xlsx"; Extended properties= "Excel 12.0; Hdr=yes "')... [sheet1$]2This error does not occur when you use the Import tool to read Excel. 3. Method: SQL Server (MSSQLSERVER) and SQL full-Filter Deamon Launcher (MSSQLSERVER) Two services login to LocalSystem, but it bothered me for a long time, here to leave a record backup, but also to help those who like me to meet the headache of the soldiers. 4Change of Login status: Operate in Configuration Manager. Updates the database update Tuser based on the contents of the Excel tableSetEmadd=A.em from(Select* fromOpenDataSource ('microsoft.ace.oledb.12.0',           'Extended properties= "Excel 12.0; Hdr=yes;imex=1 ";D ata source=" D:\em.xls "'           )... [sheet1$]) AwhereTuser.id=a.id inserting the contents of an Excel table into a database insert into Test (NAME,RE,JJ)Select* fromOpenDataSource ('microsoft.ace.oledb.12.0',           'Extended properties= "Excel 12.0; Hdr=yes;imex=1 ";D ata source=" D:\em.xls "'           )... [sheet2$]

Update the SQL database based on the contents of the Excel table