Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 excel with database verification

Author  Topic 

jaysysa
Starting Member

3 Posts

Posted - 2014-06-03 : 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.


jay
   

- Advertisement -