R u using excel 2007 or other version


On Nov 19, 8:29*am, will07 wrote:
Hi. *I have a Excel workbook with 12 worksheets. *I want to be able to
retrieve data stored in an Access table and import that data into the last
worksheet. Is there a code that will enable a permanent link and refresh each
time I open the Excel workbook.

Thanks