Topic: ADODB CopyFromRecordset
All good afternoon!
I do outswapping from a DB in Excel
If result the order 500 lines all is preempted normally.
At to sampling the error takes off that there is no storage at line:
Sheet. Range ("A1").CopyFromRecordset rs
Real sampling of the order of 5 million lines.
It is possible to envelop somehow in a cycle that on an one million floor wrote down, saved in a file and further?
P.s. c VB for the first time. I do with the help hta