Hi
I am new to Access. I want to import 2 excel files and then compare them in Access. However, some of the cells in the excel file are empty, which is expected (the data in the excel files is from a business objects report) When I import the data to Access, I want to ensure that when the 2 excel files are compared Access recognises these empty cells and matches them up - (they should match, empty cell in file 1 v empty cell in file 2 should be a match) but Access does not seem to want to show these as matches. How can I get Access to work the way I want it to?
Many thanks
Will