Update Tables

  • Thread starter Thread starter mohd21uk via AccessMonster.com
  • Start date Start date
M

mohd21uk via AccessMonster.com

I have an access database where I import data from an enterprise system. I
have then split the data into several tables to normalise it which has
created a duplicate table. I am just wondering how I could update these
tables when I re-import the tables from excel. Any help would be greatly
appreciated.
 
Rather than import the Excel sheet, Link to it.
Then you will need some queries to put the data in the correct tables.
For each table, you will need at least two queries.
An Append query to add new records to the table.
An Update query to modify data that has changed.
 
Back
Top