Saving Recordsets
 

Using Excel 2000 under Win 2K Pro with ADO 2.5

Does Excel provide any easy way to copy the results of a database query (in
the form of an ADODB.Recordset object) onto a Worksheet? Any thing as easy
as assigning an array to a Range? Or do I have to loop through all the
Fields for each record and copy them "manually"?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Saving Recordsets
 

Hi William,

Range("A1").CopyFromRecordset rsData
which uses part of the Excel Object Model (Range), and the CopyRecordset
method.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"William Barnes" wrote in message
...
Using Excel 2000 under Win 2K Pro with ADO 2.5

Does Excel provide any easy way to copy the results of a database query
(in
the form of an ADODB.Recordset object) onto a Worksheet? Any thing as easy
as assigning an array to a Range? Or do I have to loop through all the
Fields for each record and copy them "manually"?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Saving Recordsets
 

Thanks for the prompt response, Bob. Just what I was looking for!

"Bob Phillips" wrote in message
...
Hi William,

Range("A1").CopyFromRecordset rsData
which uses part of the Excel Object Model (Range), and the CopyRecordset
method.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"William Barnes" wrote in message
...
Using Excel 2000 under Win 2K Pro with ADO 2.5

Does Excel provide any easy way to copy the results of a database query
(in
the form of an ADODB.Recordset object) onto a Worksheet? Any thing as
easy
as assigning an array to a Range? Or do I have to loop through all the
Fields for each record and copy them "manually"?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Saving Recordsets
 

One other thing, now that I think of it. What about the reverse? Is there an
easy way to generate a Recordset from a Range object?
"Bob Phillips" wrote in message
...
Hi William,

Range("A1").CopyFromRecordset rsData
which uses part of the Excel Object Model (Range), and the CopyRecordset
method.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"William Barnes" wrote in message
...
Using Excel 2000 under Win 2K Pro with ADO 2.5

Does Excel provide any easy way to copy the results of a database query
(in
the form of an ADODB.Recordset object) onto a Worksheet? Any thing as
easy
as assigning an array to a Range? Or do I have to loop through all the
Fields for each record and copy them "manually"?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Saving Recordsets
 

Don't think so William, you need to handle that.

By the way, on the original question, there is also the GetRows method that
load an RS into an array

arrayData = oRS.GetRows

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"WIlliam Barnes" wrote in message
...
One other thing, now that I think of it. What about the reverse? Is there
an
easy way to generate a Recordset from a Range object?
"Bob Phillips" wrote in message
...
Hi William,

Range("A1").CopyFromRecordset rsData
which uses part of the Excel Object Model (Range), and the CopyRecordset
method.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"William Barnes" wrote in message
...
Using Excel 2000 under Win 2K Pro with ADO 2.5

Does Excel provide any easy way to copy the results of a database
query
(in
the form of an ADODB.Recordset object) onto a Worksheet? Any thing as
easy
as assigning an array to a Range? Or do I have to loop through all the
Fields for each record and copy them "manually"?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Saving Recordsets
 

Thanks again. I guess I'm not surprised since the CopyFromRecordset method
doesn't copy the field names.

"Bob Phillips" wrote in message
...
Don't think so William, you need to handle that.

By the way, on the original question, there is also the GetRows method
that
load an RS into an array

arrayData = oRS.GetRows

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"WIlliam Barnes" wrote in message
...
One other thing, now that I think of it. What about the reverse? Is
there
an
easy way to generate a Recordset from a Range object?
"Bob Phillips" wrote in message
...
Hi William,

Range("A1").CopyFromRecordset rsData
which uses part of the Excel Object Model (Range), and the
CopyRecordset
method.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"William Barnes" wrote in message
...
Using Excel 2000 under Win 2K Pro with ADO 2.5

Does Excel provide any easy way to copy the results of a database
query
(in
the form of an ADODB.Recordset object) onto a Worksheet? Any thing
as
easy
as assigning an array to a Range? Or do I have to loop through all
the
Fields for each record and copy them "manually"?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----