View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
will07 will07 is offline
external usenet poster
 
Posts: 28
Default Linking to Access Table

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