Hello All,
I have an Access Query that I need to transfer to an existing Excel
worksheet- not create a new worksheet. It's something I'll do on a regular
basis, so I'd like to eventually automate the process. I know there's a way
to do it, but I'm just uncertain how to do it.
Any geeks out there who can help me?
Thanks,
Sandy
Klatuu - 28 Sep 2005 16:12 GMT
The only way I know to do this is to create an instance of Excel, Open the
workbook, select the cell in the worksheet where you want the data to begin,
then use the CopyFromRecordset method.
> Hello All,
>
[quoted text clipped - 8 lines]
>
> Sandy