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!