Query to EXCEL - SQL Server Forums

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

Other Forums

Other Topics

Query to EXCEL

Author

Topic

revving_high
Starting Member

3 Posts

Posted - 2004-10-14 : 20:14:45

Hello All,

need help as to how to import result of query
to excel from query analyzer.

thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-14 : 20:32:26

You can use DTS for this.

Tara

kselvia
Aged Yak Warrior

526 Posts

Posted - 2004-10-14 : 22:55:39

You can also use T-SQL;

SELECT *
into #temp
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\server\share\path\book1.xls;HDR=Yes', [Sheet1$])

--Ken
I want to die in my sleep like my grandfather, not screaming in terror like his passengers.

revving_high
Starting Member

3 Posts

Posted - 2004-10-15 : 14:53:37

Thanks a lot for all your responses, i'll give this a shot.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources