Access/Excel Import Link Question

S

Sandy

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
 
K

Klatuu

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.
 
Top