InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:27:41 GMT20http://www.sqlservercentral.com/Forums/Topic770119-146-1.aspxIf you are [b]NOT[/b] using Excel 2007 read the following ariticle which also has sample code.[url]http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/[/url]10:09 - spelling correctionThu, 13 Aug 2009 08:09:13 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic770119-146-1.aspxHi all, I am trying to Export query result to Excel sheet it gives error.Code :USE DBNAMEGOEXEC sp_configure 'show advanced options', 1GORECONFIGUREGOEXEC sp_configure 'Ad Hoc Distributed Queries', 1GORECONFIGUREGOINSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\Citys\city.xls;','SELECT city_id,city,state_Id,state FROM [Sheet1$]')SELECT City_id,City,state_Id,(Select State From State Where state_id=S.state_id) AS statefrom city S where status_ind='A'AND city NOT IN (Select city from LatestZipcodes)It gives error message like:Msg 7399, Level 16, State 1, Line 3The OLE DB provider "Microsoft.Jet.OLEDB.4.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 3Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".pls help me.Thu, 13 Aug 2009 07:10:22 GMTvenki_1276