MS Access database support - Another Excel Automation Newbie Question

Author

Another Excel Automation Newbie Question

Keith Wilby

2006-04-07, 7:42 am

If I have a query with one field I can write the results to an existing
Excel spreadsheet using

objSht.Range("BK22").CopyFromRecordset rs

What happens if my query has two fields but I only want to write one of them
to the spreadsheet? I thought I could reference the field using either

objSht.Range("BK22").CopyFromRecordset rs("Result")

or

objSht.Range("BK22").CopyFromRecordset rs![Result]

but both silently fail ("Result" is an alias in the query). Any clues?

Many thanks.
Keith.

Randy Harris

2006-04-07, 9:37 am

Keith Wilby wrote:
> If I have a query with one field I can write the results to an existing
> Excel spreadsheet using
>
> objSht.Range("BK22").CopyFromRecordset rs
>
> What happens if my query has two fields but I only want to write one of them
> to the spreadsheet? I thought I could reference the field using either
>
> objSht.Range("BK22").CopyFromRecordset rs("Result")
>
> or
>
> objSht.Range("BK22").CopyFromRecordset rs![Result]
>
> but both silently fail ("Result" is an alias in the query). Any clues?
>
> Many thanks.
> Keith.
>
>

Keith, I think the syntax you want is:

objSht.Range("BK22"). CopyFromRecordset(rs
, , 1)

HTH
--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

Sponsored Links