Access/Excel Import Link Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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