Forum Discussion
Adagio
Frequent Contributor
So I'm trying to run a SQL query on production data which would flag some transactions, export them in a spreadhsheet and save it in a location. A notification goes out to someone to review these faulty transactions.
I can still do all of this but not so quick. When the program reads the query results row by row and copies to the excel, it takes 2 minutes/1000 rows. I'm trying to make it <10 sec.
Thank you
Abhi
AlexKaras
6 years agoChampion Level 3
Hi,
A variation of what was suggested by anupamchampati:
https://www.sqlservercentral.com/Forums/912903/exporting-ADO-recordset-straight-into-CSV-or-Excel (.CopyFromRecordset() method).
Related Content
Recent Discussions
- 2 days agovladd1