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 |
|
jodders
Starting Member
41 Posts |
 Posted - 2014-06-24 : 07:28:12
|
| Hi guys,I have this script which outputs a combination of financial data. I have recently joined a table that includes a narrative and when I run the query, it runs perfectly. However, when I copy and paste the output into Excel, not all the data is showing. After the process of elimination, it is because Excel doesn't like the narrative column and not all data is copied across which is very annoying. If I remove the narrative column, then all the data copies over correctly. I am using Excel 2010 which is quite up-to-date. Has anybody experienced this before or know of a work around when copy and pasting their output into excel?Many thanksJ |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-06-24 : 07:50:15
|
| Kinda hard to answer without seeing you query and some sample data. Hopefully you're not blowing past Excel's limits:Max cell size: 32,767 charactersMax number rows: 1,048,576 |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-25 : 01:38:17
|
| What are the details of the narrative column? how wide?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-06-25 : 02:18:43
|
Is the script in Excel updated to include the new column?
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|
|
|
|
SQL output not all showing in Excel