Hi all,

I have Access and Excel 2003. I have a query that returns about 3K
rows. When the query returns the records, I can do a bulk copy by right
clicking on the upper left corner and select copy and just paste the
entire recordset onto Excel. Is there a way to do that in code rather
than writing out each record field-by-field? There's about 50 fields and
it takes way too long. Please show me a code snippet to accomplish this
task. Thanks in advance for sharing your thoughts.


Ben

Look at the TransferSpreadsheet method. You can specify the query name
rather than a table name.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Ben" <(E-Mail Removed)> wrote in message
news:eh58x8P%(E-Mail Removed)...
> Hi all,
>
> I have Access and Excel 2003. I have a query that returns about 3K rows.
> When the query returns the records, I can do a bulk copy by right clicking
> on the upper left corner and select copy and just paste the entire
> recordset onto Excel. Is there a way to do that in code rather than
> writing out each record field-by-field? There's about 50 fields and it
> takes way too long. Please show me a code snippet to accomplish this
> task. Thanks in advance for sharing your thoughts.
>
>
> Ben

This is a GREAT resource:
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

These two are probably most relevant to your post:
http://www.accessmvp.com/KDSnell/EXC...ExportSepFiles
http://www.accessmvp.com/KDSnell/EXC...ExportSameFile

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Douglas J. Steele" wrote:

> Look at the TransferSpreadsheet method. You can specify the query name
> rather than a table name.
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
>
> "Ben" <(E-Mail Removed)> wrote in message
> news:eh58x8P%(E-Mail Removed)...
> > Hi all,
> >
> > I have Access and Excel 2003. I have a query that returns about 3K rows.
> > When the query returns the records, I can do a bulk copy by right clicking
> > on the upper left corner and select copy and just paste the entire
> > recordset onto Excel. Is there a way to do that in code rather than
> > writing out each record field-by-field? There's about 50 fields and it
> > takes way too long. Please show me a code snippet to accomplish this
> > task. Thanks in advance for sharing your thoughts.
> >
> >
> > Ben
>
>
> .
>