Use QueryTables to write Excel data back to Access

I am using QueryTables to display information in an Excel 2010 worksheet. I want users to be able to make changes in the Excel table, and for those changes to be written back to the Access tables. I thought it was as easy as specifying mode=ReadWrite in the connection string, but that doesn't seem to do the trick.

Right now if changes are made in Excel, the same changes are not being made in Access, and if the user presses the "Refresh" button, the changes are over-written with the original data. I've pasted my connection string below. Is there another setting I need to make in addition to the mode=ReadWrite setting in the connection (or a separate QueryTable setting) in order to make the Excel table sync with / write data back to Access? Thanks!

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\DEV\TestDB.accdb;Mode=ReadWrite;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False

PS -- if there is another best practice for doing this besides QueryTables, let me know. I have used ADODB elsewhere for more complex problems, but this is simply trying to sync a few tables from Access to Excel & back to Access. I figured QueryTables was the best choice for this, but if there's a better way let me know. Thanks!

My guess is either (1) true read/write functionality is not available via QueryTables, or (2) the answer to this question was so obvious/easy (despite my many attempts to construct a Google search to find it) that it was not worth answering. In either case, I thought I'd provide one answer to my own question, in case anyone with a similar question stumbles upon this post.

This can be done with ADO and SQL. I won't provide the full steps/code for using ADO or worksheet events (that can easily be found elsewhere via Google / Excel Forums search), but here are the basic steps:
- retrieve the data from Access using ADODB: (e.g. "rngMyRange.CopyFromRecordset rsMyRecordset")
- monitor the Worksheet_Change event
- when a change happens, test if it's within the data table
- Use ADO to construct & execute an update query on the Access database: "UPDATE <table name> SET <field name> = <value> WHERE <criteria>;"

If you're just trying to sync one table, the above is probably way more than you need (given the code required to manage the ADODB connection), but if it's part of a larger project it makes sense. It also gives you added flexibility in Excel such as:
- breaking the table up or inserting columns between fields
- adding Forms or ActiveX controls to the Excel range / table
- including cell validation lists in the table (not sure if this one is possible within QueryTables)
- pretty much doing anything you're willing to write code for, since the table (Excel range) is not formally linked to Access.