During testing, I was asked to give the testers an Excel file containing the raw data that was used as a basis for the summary so I needed to give them the whole tblSales for them to check.
I displayed the data using the simple code
SELECT * FROM tblSales
and the code ran for almost 35 minutes and displayed 830,000+ rows.
I wanted to copy the rows displayed and paste them to the Excel file but afer copy, a System Out of Memory exception was displayed in a messagebox. I tried copying it about three or 4 times and it showed the same error. Then, my computer crashed, SQL closed, and the table displayed after a 35-minute runtime for the query was lost. So I needed to query it again.
So what should I do to successfully transfer the data to excel without encountering this error? Any advice?