Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking to Access table | Excel Discussion (Misc queries) | |||
HELP linking access table to excel | Excel Worksheet Functions | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
Linking Large Access Table into Excel | Links and Linking in Excel | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming |