Posted - 06/03/2014 : 12:02:03
| i have used this query:
query = "select c.* from emp as c innerjoin(select * from openrowset('microsoft.ACE.OLEDB.12.0','database=E:\excel to db\exceldb.xlsx;hdr=yes','select * from [sheet1$])"
here i am comparing exceldb excel sheet with emp database for checking data in excel is present in db or not
i have refered this link for query : http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=146241
but i am getting error as :
The OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "(null)"
pls help me to execute
Thanks in advance.