Excel spreadsheet and Access database integration

M

Mamer

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?

Thanks!
 
J

John Nurick

Hi Mamer,

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.
 

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

How to automate update on weekly reports spreadsheet 0
Integrating information from Word to Excel (not mail merge) 1
Need Help with Macro Security 1
Using Access Database to build contracts with fields on pdf document 0
Mail Merge Directory Conditional Page Break 0
Excel - Wich Function should I use? 1
Linking data in MS Word into Excel 5
Using Office Forms and dynamically updating the excel backend 0

Top