I am trying to determine a way to update multiple tables in Access from a single spreadsheet in Excel. I need to be able to change data in an existing record based on the Excel spreadsheet (only if something is different) and add new records if there isn't a matching record between Access and Excel.
The Excel file is set up so each project has many many columns of information. The information in certain columns needs to go to fields in certain tables.
What would be the recommendation in this situation? Are there any references to this sort of thing?