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 2005 Forums
 Transact-SQL (2005)
 Copying from Query output window

Author  Topic 

theboyholty
Posting Yak Master

226 Posts

Posted - 2009-06-03 : 08:13:47
One thing that has pissed me off for ages is this:

Occasionally people will ask for a load of data, and they just want it in excel for doing whatever the hell people do with excel these days.

Problem is, when you copy from the query output window and paste into excel, it will only paste the first 3 thousand or so records. Its a pain in the arse.

Solution?

---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-06-03 : 08:31:26
Use BCP utility

For more details

http://www.databasejournal.com/features/mssql/article.php/3391761/Utilize-BCP-with-SQL-Server-2000.htm


Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-03 : 08:37:20
Excel can have 65000+ rows
Use this to copy data to Excel
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -