excel and access
 

Excel calculates a value that I want to store in access and reuse any other
time. How do I do?

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?