October 29, 2003 at 9:45 pm
I've copied data from the results window in SQL Query analyer and then pasted the data into an Excel spread sheet resulting in missing data. The results in query analyer is 26601 rows but the pasted data in Excel is only 26460. Has anyone come across this?
October 30, 2003 at 2:07 am
QA displayed grid or text. Was rows "randomly" lost or only the last few rows. Any funny tab,carriage returns, etc. in the columns? Which version of Excel.
Maybe try the same amount of rows but only one column.
October 30, 2003 at 8:58 am
I'm working with Office 2003. When I DTS the data to Excel it works fine, but when I copy and paste the last couple 100 rows dissapear!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply