Answered by:
How resolve error OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error"

Question
-
Error:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" 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 "(null)".I am using the following query
select * from openrowset('Microsoft.ACE.OLEDB.12.0'
,'Excel 12.0;Database=\\abc\k\excel.xlsx',[sheet1$])driver Microsoft.ACE.OLEDB.12.0 installed and configure properly.
Any help ?
Thursday, April 9, 2015 12:18 PM
Answers
-
See if this helps
http://visakhm.blogspot.ae/2013/12/how-to-solve-microsoftaceoledb120-error.html
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page- Marked as answer by pituachMVP Saturday, May 14, 2016 11:11 PM
Thursday, April 9, 2015 12:28 PM -
Check this link: http://sqlwithmanoj.com/2012/07/10/querying-excel-2010-from-sql-server-in-64-bit-environment/
You might need to register the ACE OLEDB provider, go thru all the steps I've mentioned in my blog, may help.
Are you getting any other error also?
~manoj | email: http://scr.im/m22g
http://sqlwithmanoj.wordpress.com
MCCA 2011 | My FB Page- Edited by Manoj Pandey (manub22)Microsoft employee Thursday, April 9, 2015 1:00 PM
- Marked as answer by pituachMVP Saturday, May 14, 2016 11:12 PM
Thursday, April 9, 2015 12:59 PM
All replies
-
See if this helps
http://visakhm.blogspot.ae/2013/12/how-to-solve-microsoftaceoledb120-error.html
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page- Marked as answer by pituachMVP Saturday, May 14, 2016 11:11 PM
Thursday, April 9, 2015 12:28 PM -
Check this link: http://sqlwithmanoj.com/2012/07/10/querying-excel-2010-from-sql-server-in-64-bit-environment/
You might need to register the ACE OLEDB provider, go thru all the steps I've mentioned in my blog, may help.
Are you getting any other error also?
~manoj | email: http://scr.im/m22g
http://sqlwithmanoj.wordpress.com
MCCA 2011 | My FB Page- Edited by Manoj Pandey (manub22)Microsoft employee Thursday, April 9, 2015 1:00 PM
- Marked as answer by pituachMVP Saturday, May 14, 2016 11:12 PM
Thursday, April 9, 2015 12:59 PM