How do I compare two excel files in access?

[Guest]

I want to compare two very very large csv files and output the differences
for easy reconciliation

 

[Guest]

I will also need to know how to import the files into access as they are too
big for excel. Words and pictures please!!!

 

[MGFoster]

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.