I am working to pull data from a SQL database. In SQL Server 2005, I save the results as a CSV file (Version 2013). Sometimes (no rhyme or reason) some of the data is truncated.
If I copy the data from the SQL Query Results and paste into Excel, the data is truncated
If I copy the data from the SQL Query Results and paste into word, the data is not truncated.
I have over 1/2 million rows to export into Excel and pasting into Word first is not a viable option.