ITSAdmin
asked on
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]');
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.