Import & compare

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SCOOBYDOO - 05 Apr 2005 16:31 GMT

How do I import 2 csv files and compare the data and identify differences.
New user so please respond with full instructions please!! Thanks

Reply to this Message

John Nurick - 05 Apr 2005 20:48 GMT

Import the files into two separate tables (File|Get External
Data|Import). Then use the Find Unmatched query wizard to identify
records that exist in one table but not the other (and vice versa).

>How do I import 2 csv files and compare the data and identify differences.
>New user so please respond with full instructions please!! Thanks

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

app - 21 Apr 2006 12:22 GMT

Hi,

you can use http://csvdiff.sourceforge.net/ to compare / diff two csv files.

Yours

app

Reply to this Message