Export Query result to Excel Sheet

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Export Query result to Excel Sheet

Export Query result to Excel Sheet

Rate Topic

Display Mode

Topic Options

Author

Message

venki_1276

Posted Thursday, August 13, 2009 7:10 AM

Valued Member

Group: General Forum Members
Last Login: Monday, November 23, 2009 9:34 PM
Points: 68, Visits: 64

Hi all,

I am trying to Export query result to Excel sheet it gives error.

Code :

USE DBNAME
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO

INSERT 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 state
from 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 3
The 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 3
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

pls help me.

Post #770119

bitbucket-25253

Posted Thursday, August 13, 2009 8:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 5,103, Visits: 20,220

If you are NOT using Excel 2007 read the following ariticle which also has sample code.
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

10:09 - spelling correction

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #770181

« Prev Topic | Next Topic »

Permissions