I have SQL code that pulls data into an Excel spreadsheet using the statement ".CopyFromRecordset rs".
Is it possible to cancel the copy mid copy? Pressing the ESC key does not stop the code.
Your suggestions are appreciated.
SQL CopyFromRecordset
-
jstevens
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
SQL CopyFromRecordset
Regards,
John
John
-
HansV
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands