Re: Writing Excel cells within Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Bonta (bob.bonta_at_jte.osd.mil)
Date: 03/14/05 

Date: Mon, 14 Mar 2005 06:38:04 -0800

Thank you Chris. What you suggested is exactly my
intention (perhaps I wasn't clear enough in my original
post.).

Do you have a sample of how to write to Excel cells from
within Access?

Bob
>-----Original Message-----
>
>"Bob Bonta" <bob.bonta@jte.osd.mil> wrote in message
>news:859d01c5289d$7430aa10$a401280a@phx.gbl...
>> Hey folks - I'm looking for a sample code snippet on
>> writing to an Excel spread*** one cell at a time from
a
>> query built within MS Access.
>>
>> Any assistance is greatly appreciated.
>>
>> Thanx!
>>
>> Bob
>
>Bob,
>
>A Query (QueryDef) in MS Access cannot send information
to MS Excel.
>
>You will need to write VBA code, instantiate a recordset
(you can name
>an existing QueryDef when you do this), and then loop
through the
>recordset, writing out to the MS Excel "cells" based on
whatever
>conditions are appropriate.
>
>
>Sincerely,
>
>Chris O.
>
>
>.
>

Quantcast