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
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks