Update existing Access tables from Excel using VBA in Access

[Cudaboy]

Hey All!

I have an Access 2016 database that I want to use VBA in the database so when it opens it updates the table data with data in an excel spreadsheet in a different network folder. this has to be automated for the user. let's just start with a table named "Summary" and I can go from there. I can append OK, but cannot update. No code has been written as yet so I am starting from scratch. Thanks in advance!

 

[Cudaboy]

You are correct, xenou. Thankfully there is only one user at a time. That user, however, wants to use the laptop in an environment with no network access and still use a networked copy when back at their desk so information can be hand-transferred to other systems. Since I last posted I am thinking about more ways I can alert the user. Like tagging the date/time the last "Sync" was done and storing it in both copies of the databases and somehow using that along with the back-end file attributes to decide which data set is most current. Lots to consider!