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 |
|
ravl13
Starting Member
38 Posts |
 Posted - 2011-10-19 : 17:40:03
|
| Greetings,When you execute a query in management studio, if you have the output as grid view, you are able to copy and paste the results into Excel easily, with each cell of the Management Studio output getting its own respective cell in the Excel spreadsheet. However, if I copy and paste the same grid output into OpenOffice Calc (the program that's similar to Excel), the results are not pasted the same way they are in excel, and are brought into the calc spreadsheet as a large glob of values with commas in between them which are all stored in one cell. There are options to specify delimiters and what the escape characters are when you paste the data into Calc (a dialog box pops up), but I have no idea how the data is stored when I copy it in Management studio. Does anybody know what I have to specify in that pop-up window when I try to paste into OpenOffice Calc? I'd like it to behave the same as when you paste the data in Excel.Thanks!-ravl13 |
|
|
ravl13
Starting Member
38 Posts |
Posted - 2011-10-20 : 16:19:28
|
| Oh, I feel stupid. It turns out that the copied data is stored by tabs, even though it LOOKS like comma separation, so if you pick tabs as the delimiter, it pastes fine. |
 |
|
|
|
|
|
Copying/Pasting query output to OpenOffice Calc