MSSQL - Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server
I created a linked server (Excel_EmployeeTable) for an Excel spreadsheet, which is located at C:\Temp\Employee Table.xlsx. I am trying to get information out of the 'Staff' worksheet.
I tried to query by using the following two different queries, both of which end up with the same error message.
First query...
Second query...
OS: Microsoft Windows 7 Enterprise 64-bit
Office: Microsoft Office 2010 Standard 32-bit
SQL: Microsoft SQL Server Enterprise (tried 32-bit and 64-bit)
Any ideas on how to fix this?
I tried to query by using the following two different queries, both of which end up with the same error message.
First query...
select *
from Excel_EmployeeTable...[Staff$];
Second query...
select *
from openquery(Excel_EmployeeTable, 'select * from [Staff$]')
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "Excel_EmployeeTable" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "Excel_EmployeeTable".
OS: Microsoft Windows 7 Enterprise 64-bit
Office: Microsoft Office 2010 Standard 32-bit
SQL: Microsoft SQL Server Enterprise (tried 32-bit and 64-bit)
Any ideas on how to fix this?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I was able to use a bulk insert and was able to import the data.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://visakhm.blogspot.in/2013/12/how-to-solve-microsoftaceoledb120-error.html