SQL Server: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server

Categories: Database; Tagged with: SQL • SQL Server • T-SQL; @ September 13th, 2012 18:41

I got some Error when I trying to select data from Excel file using Microsoft.Jet.OLEDB.4.0:

The OLE DB provider “Microsoft.Jet.OLEDB.4.0” for linked server “(null)” reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider “Microsoft.Jet.OLEDB.4.0” for linked server “(null)”.

Solution:Make sure you can access the file from the DB server.

SQL Server: Read,Write data from Excel/CSV/Text file using T-SQL <-> SQL Server: New Linked Server from Excel