Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel and access
Excel calculates a value that I want to store in access and reuse any other
time. How do I do? |
#2
|
|||
|
|||
If it's a single value, it's easier to use the registry with the GetSetting
and SaveSetting functions (check out HELP). If it's a large amount of data... In Access, using File / Get External Data / Link Tables, point to your Excel information. In Excel, create a Data Query pointing to the info in Excel OR just reference the information from one workbook to the other and don't use Access. HTH, Gary Brown "johnny nielsen" wrote: Excel calculates a value that I want to store in access and reuse any other time. How do I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |