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

Linking to Access Table
 

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

Linking to Access Table
 

I am using Excel 2003 Version

Thanks

"muddan madhu" wrote:

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

.