Updating access with additional records in excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created my Access DB from excel. Now I want to update the DB with new
data that was added to Excel (not fields just new records) how do I go about
doing this?
 
1. Import the new data to the MDB
2. Create a query using the wizard, Unmatch records query, which are the
records that apear in the table that you just imported and not in the Access
table
3. Change the query to Append query, and append all the new records

Note, Back up your data first
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Data consolidation 1
Need Help Please 5
add new excel row, when a new access record is added. 2
Can you update - not append- records in access with excel upload? 1
Importing Additional Excel records 1
Access Clear all records in access 2
HELP A NEWBIE - EXCEL TO ACCESS 5

Back
Top