I'm using ADO to retrieve records from a database. However, the records are
automatically being stored in sheet1. How do I specify which sheet I want
the records to be stored in. I am using the following line of code to copy
from the recordset...

Range("A1").CopyFromRecordset rst

Thank you inadvance!

Worksheets("Sheet2").Range("A1").CopyFromRecordset oRS
--

HTH

RP
(remove nothere from the email address if mailing direct)


"JJ" wrote in message
...
I'm using ADO to retrieve records from a database. However, the records
are
automatically being stored in sheet1. How do I specify which sheet I want
the records to be stored in. I am using the following line of code to
copy
from the recordset...

Range("A1").CopyFromRecordset rst

Thank you inadvance!

I appreciate it, thanks!

"Bob Phillips" wrote:

Worksheets("Sheet2").Range("A1").CopyFromRecordset oRS
--

HTH

RP
(remove nothere from the email address if mailing direct)


"JJ" wrote in message
...
I'm using ADO to retrieve records from a database. However, the records
are
automatically being stored in sheet1. How do I specify which sheet I want
the records to be stored in. I am using the following line of code to
copy
from the recordset...

Range("A1").CopyFromRecordset rst

Thank you inadvance!