This error may be reported when SQL Server 2008 reads Excel data: Cannot create an instance of the OLE DB provider "MSDASC" of the linked server "(null)". 1. This error occurs primarily when reading data using code: INSERT INTO database table name
SELECT * from OpenDataSource (' microsoft.ace.oledb.12.0 ', ' Data source= ' d:\Excel table name. xlsx "; Extended properties= "Excel 12.0; Hdr=yes "') ... [sheet1$] 2. This error does not occur when you use the Import tool to read Excel. 3. Method: Change the login status of SQL Server (MSSQLSERVER) and SQL Full-filter Deamon Launcher (MSSQLSERVER) Two services to LocalSystem, but it's been bothering me for a long time, Leave a record here and help the Warriors who have the same headache as I do. 4. Change of Login Status: Operate in Configuration Manager.
About OLE DB providers for "Unable to create linked server" (NULL)