How do I compare two excel files in access?

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

Guest

I want to compare two very very large csv files and output the differences
for easy reconciliation
 
I will also need to know how to import the files into access as they are too
big for excel. Words and pictures please!!!
 
You can use the DOS command FC. Read the PC Help file for more info.

To import the files you can use the menu item:

File > Get External Data > Import

Then navigate to the file you want to import.
 
Back
Top