[MS SQL Server] Error while importing to excel

---

Error while importing to excel Posted: 16 Aug 2013 04:33 PM PDT Hi, I am trying to import sample data into excel,using following code,but it gives me following error,Create Table Test(a Varchar(2),b Varchar(2))Insert Into testvalues ('ab','bc')insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0; database= D:\test' ,'SELECT * FROM [Sheet1$]')select * from testMsg 7399, Level 16, State 1, Line 2The 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.Msg 7303, Level 16, State 1, Line 2Cannot initialize the data source object of OLE DB provider "microsoft.ace.oledb.12.0" for linked server "(null)".

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610