By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,559 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

How to update the access database and find differences

P: 3
I imported an excel spreadsheet into an access table. There has been updates to the excel sheet, but I'm not entirely sure what, so I would like to import this new excel sheet into the same access database and then find out (probably run a query or report) what changes were made in the data. Any ideas?

Someone editted the excel sheet, so now I need to update the access database. The access table and excel spreadsheet are exactly the same layout. I have around 500 rows and 20 columns. The problem is that I don't know what has been editted in the excel sheet so I would like to compare the two tables. The problem with using the wizard query is that I can only compare one column, and not all of my columns and data. I would like to find records that exists in the 1st table, but not in the new table, as well as records which exists in the new table, but not in the 1st table. Help!
Jan 8 '13 #1
Share this Question
Share on Google+
2 Replies

Seth Schrock
Expert 2.5K+
P: 2,944
I assume that deleting what is already in Access and replacing it with the current Excel data isn't an option?

Here is something that might help: Compare two tables and find unmatched records. I have never used this so I'm not exactly sure how this works or what it defines as unmatched.

A very complicated way would be to loop through the two recordsets and if any of the records don't match, the record could be added to a new recordset that could be viewed in a form. Depending on the amount of data in your tables, this could take a while and might not be the best method, but it would work.
Jan 8 '13 #2

Expert Mod 15k+
P: 31,606
You could link an Access table to the worksheet instead. You would still need to compare the data from the two tables, but we'd need some actual information from you before we could help with that. Your question leaves a lot to be desired, but should be fine if you can work with what's already been posted. If you need more help then you'll need to provide more and better information on the problem first.
Jan 9 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.