I have just re-designed an Access database, normalizing the existing database of 2 tables into 10+ tables. Previously updating the database was easy as you could do a direct import from a spreadsheet to append the data to the tables.
What I want to do is the same thing but now I have to update many tables. I am struggling to come to terms with how I can update data in a relational database.
As I understand it one way would be to create an append query and specify exactly where each corresponding column of data needs to be stored in the database. Is this correct?
Using Excel and VBA I was thinking of setting up a template with columns from many different tables to update the database with the click of a button. Is this a good solution, has anyone tried this and/or have any recommendations?
Thank you!