Hi there,
Wondering if this is even possible - but can I achieve the following?
1. Link excel sheet to Access db as a linked table (Sheet1)
2. Have a local table that contains all of the fields of the linked table (Students)
3. Run an update query that will pull all of the data changes from Sheet1 into that of Students
Any assistance would be vastly appreciated!
Cheers
Boost