I need to copy the recordset to a spreadsheet in dao you can use
copyrecordset but I can't find it in ADO can someone tell me how this is done
in ado please.
Charles

Charles,

It also exits in ADO, in Excel 2000 up at least.

Here is an example of some of my code that uses it

' Check to make sure we received data.
If Not oRS.EOF Then
Sheet1.Range("A1").CopyFromRecordset oRS
Else
MsgBox "No records returned.", vbCritical
End If



--
HTH

Bob Phillips

"vqthomf" wrote in message
...
I need to copy the recordset to a spreadsheet in dao you can use
copyrecordset but I can't find it in ADO can someone tell me how this is
done
in ado please.
Charles

Thanks I looked in the help files but found no reference to it.

"Bob Phillips" wrote:

Charles,

It also exits in ADO, in Excel 2000 up at least.

Here is an example of some of my code that uses it

' Check to make sure we received data.
If Not oRS.EOF Then
Sheet1.Range("A1").CopyFromRecordset oRS
Else
MsgBox "No records returned.", vbCritical
End If



--
HTH

Bob Phillips

"vqthomf" wrote in message
...
I need to copy the recordset to a spreadsheet in dao you can use
copyrecordset but I can't find it in ADO can someone tell me how this is
done
in ado please.
Charles

If you type copyfromrecordset in the immediate window, put the cursor in the
word, and then hit F1, you should find it

--
HTH

Bob Phillips

"vqthomf" wrote in message
...
Thanks I looked in the help files but found no reference to it.

"Bob Phillips" wrote:

Charles,

It also exits in ADO, in Excel 2000 up at least.

Here is an example of some of my code that uses it

' Check to make sure we received data.
If Not oRS.EOF Then
Sheet1.Range("A1").CopyFromRecordset oRS
Else
MsgBox "No records returned.", vbCritical
End If



--
HTH

Bob Phillips

"vqthomf" wrote in message
...
I need to copy the recordset to a spreadsheet in dao you can use
copyrecordset but I can't find it in ADO can someone tell me how this
is
done
in ado please.
Charles