Read/write Excel to Access

[stoolpidgeon]

Can I pick this thread up? Addresses an issue I'm having... I have an access db storing the entire divisions workload, and individual excel files querying the access db to retrieve just the work applicable to them that is outstanding (so query conditional on two fields; employee name and whether work is complete or in progress (true/false)). What I want to achieve is that employees can mark their work as Complete and this should communicate to the access db that it is complete so that upon refreshing their table in excel, the completed work is no longer populated. Is this possible?

EDIT: This post was split off from another thread because it's a new topic.
Moderators

 

[SydneyGeek]

This can be done using VBA. Take a look at this tutorial. Among other things it shows you how to download selected records from an Access table, and edit/update from Excel.
If you are using Access 2007 or later with an .accdb database format you will need to change the Porvider from "Microsoft.Jet.OLEDB.4.0" to "Microsoft.ACE.OLEDB.12.0"

Denis