Monday, January 30, 2012

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered


If you run below SQL statement
---------------------------------------------------------
Select * into DBTable FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\myExcelFile.xlsx;HDR=YES', 'SELECT * FROM [Sheet1$]')




INSERT INTO DBTable select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\myExcelFile.xlsx;HDR=YES', 'SELECT * FROM [Sheet1$]')
--------------------------------------------------------


and you get an error message like below
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered


Solution
you need to download 
"Data Connectivity Components for 2007 office system Driver".
after you download, please restart your server.


you can click link here to download from microsoft site.


you will able to saw your microsoft excel driver 12.0 in your Data Sources(ODBC) in control panel

2 comments:

fgdg said...

Fear not that the life shall come to an end, but rather fear that it shall never have a beginning Sell RS Gold, What gets us into trouble is not what we don't know.It's what we know for sure that just ain't so Sell Runescape Gold, Life is like a hot bath. It feels good while you're in it, but the longer Sell RS Gold you stay in, the more wrinkled you get.

fgdg said...

Do not pray for tasks equal to your powers.Pray for powers equal to Buy rs gold your tasks.Then the doing of work shall be no miracle, but you shall be the miracle, Fear not that the life shall come to an end, but rather fear that Runescape Money it shall never have a beginning,. At twenty years of age Runescape2 Money., the will reigns; at thirty, the wit; and at forty, the judgment.