excel and access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to Fix Damaged Excel File That Won't Open? 3
Access #Error & Excel Pivot 0
Scrabble Value calculation for Welsh words 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Browse button for access form 1
Excel Functions 2
Exporting MS Project Values into Excel 2
How to test for imported Access table null cell? 3

Back
Top