Linking to Access Table

[will07]

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

 

[muddan madhu]

R u using excel 2007 or other version

 

[will07]

I am using Excel 2003 Version

Thanks

R u using excel 2007 or other version




.