Does anyone know if and how I could link a database to an Excel spreadsheet and have the database automatically update thru some type of recalculate command?
There are various possibilities depending on just what the situation is,
including:
- use File|Get External Data to link to the spreadsheet and treat it as
an Access table.
- use VBA code running in Excel to manipulate the database using the DAO
library (assuming the database is in an mdb file). This way, your code
doesn't actually use Access, but the updated data is of course available
when the database is opened with access. If you search the newsgroup
microsoft.public.excel.querydao at http://groups.google.com/advanced_group_search?hl=en you'll probably
find some relevant information.
