Link Access query to refresh an EXCEL file

[Dancer4u]

I am using ACCESS 2002 and EXCEL 2002. I am trying to link an ACCESS query
to an EXCEL file that can be refreshed each month with new data. I have
downloaded ACCESS LINKS but can not find any help in how to use it to
accomplish the task above.

 

[Nick Hodge]

Dancer

Try this

http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)