I have a need to work between a new Access 2010 / 2013 database that is being built from an Excel spreadsheet. I have multiple vlookups on the one I am converting to Access but I also have multiple other excel spreadsheets that were using the data in the old Excel sheet that I am converting to Access. The project is large enough that I cannot do everything at once and so I am looking for some advice on the best way to keep everything up to date as real time as possible.
What is the best easiest way to work between the two real time and does 2013 give me any advantage over 2010?
Open to suggestions before I jump down the rabbit hole.