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.
| Author |
Topic |
|
ZMike
Posting Yak Master
110 Posts |
 Posted - 2009-06-18 : 21:53:23
|
| I have a query that I'd like to Export approx 192K records to Excel 2007. I've only sucessfully exported it to CSV in a text file this far. Is there a way to Export this much data into a newer version of Excel since it wont give me the xlsx extension. I'm fairly new to exporting 1 time data from SQL Server. Most of the queries that we use on a consistant basis go into Reporting Services. |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2009-06-19 : 08:51:27
|
You can export via a bunch of differant ways, but for me the quickest and the one I always end up using is the old copy and paste method from SSMS. If your machine does not hav a lot of RAM, then you might want to break the results into into pieces and do 50,000 records at a time.Also a quick trick is if you want the column headers to copy with the data you can set that under tools ->Options ->Query Results ->Sql Server -> Results to grid Then just check the box for it.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
ZMike
Posting Yak Master
110 Posts |
Posted - 2009-06-19 : 10:45:48
|
| Vinnie881,I just found that option last night believe it or not lol. What's the best way for me to pull say 50 to 65K records at a time. I only have 2gigs of Ram on the machine I'm on.Is there a record number feather that I can say something like(RecordNumber BETWEEN 1 AND 65000) etc? |
|
|
|
ZMike
Posting Yak Master
110 Posts |
Posted - 2009-06-19 : 10:47:59
|
| The Grid Viewer for me will only go to 65535 records and wont let me go over that. So I'll probably just break it down to 65500 records per pull. That would be fine with me. |
|
|
|
|
|
|
Exporting SQL Server 2005 to Excel 2007 ?