Load/Append 2nd Recordset to the same spreadsheet

R

rweide

I am using copyFromRecordset to load recordsets to the spreadsheet. How do I
continue to load and append the recordsets from a second SQL query to the
same spreadsheet?

I have codes like the following:

SS1.ActiveSheet.Cells.copyFromRecordset adoRs
SS1.ActiveSheet.Range("A2").Select
SS1.ActiveWindow.FreezePanes = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CopyFromRecordset with large amount of data 9
Load OWC spreadsheet in batches from recordsets 0
SQL not importing records from ACCDB 2
ado copyfromrecordset and nextrecordset 4
Lookup then Match and insert value from next column 3
VBA Coding Help for Beginner 0
A theoretical question: how best to manage perpetual recordset needs? 24
Loading recordset at runtime 4

Top