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.


Comments

Post a Comment

Popular posts from this blog

i am writing With sad hearts some problems with my windows phone samsung omnia w

Last month i bought a Windows phone Samsung Omnia W.... After a few days i realise the some problem with it...... WP7.5 (Mango) is already in its second generation but it still has many restrictions, limitations and serious usability issues. This is a list of its shortcomings as compared with other smartphone OS in the market. We are not comparing special features or abilities but those which have become the norm for all smartphones and even dumb phones. An Android, Symbian or MeeGo phone would have almost none of these shortcomings. An iphone share some restrictions with WP7.5 but is still miles ahead. Even the Nokia N9 running the first generation MeeGo OS is far better with none of the disastrous issues which impact on the sheer usability of the phone. OS LIMITATIONS 1. No true multitasking - apps are frozen in the background. 2. No Divx/Xvid video codec support. Zune will convert with loss of quality. 3. No mass storage mode. 4. No micro-SD card support. 5. Only suppor...
Read more

Delete Duplicate Records in DataBase sql server

if your Tabel has a duplicate data and you want to delete only duplicate records and want to save only single records in your table then this single line of code will help you.......... select * from tblname where tblname. %%physloc%% not in(select MAX(b.%%physloc%%)  from tblname   group by b.coloumnname) Hope it helped you........ plz comments.........
Read more