Update Tables

  • Thread starter mohd21uk via AccessMonster.com
  • 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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting Import Error Tables 3
How to connect to a BE database? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA Corrupt 3
linking tables via ODBC 2
PLEASE HELP: automate process to import tables from notepad to acc 9
Delete tables in another database via VBA 7
Append new and changed records 2

Top