Excel 2007 / SQL 2005 32-bit "Microsoft.ACE.OLEDB.12.0" has not been registered.

Ace.OleDB.12.0 is istalled yet I'm getting this error anyway???

select *
from openrowset('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;HDR=YES;Database=c:\Excel-SQL\Charges.xlsx',
'Select * from [ChargesAll]');

Open in new window

ITSAdminAsked:
Who is Participating?
 
ITSAdminAuthor Commented:
I found the problem.  Driver was not installed on SQL Server!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.