View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JCS JCS is offline
external usenet poster
 
Posts: 93
Default Comparing large CSV Files

Steve,

I think the best way to what you ask is by using MS Access. First you creat
a new database and then link the csv files (File == Get External == Link
Tables). Access will link to csv files very easily. Then create a query
that queries all 3 csv files. Now, you may have to get additional help from
the Access Users' Group. This approach should solve your problem.

John

"Steve Audus, Chaucer BEC, Sheffield UK" wrote:

We generate a csv file each night with over 10,000 records,
it's a list of classes, teachers and students.

Could anyone give me some advise on a easy way of automaticaly comparing the
one csv to another, and then creating a 3rd csv with just the differences?

Thank you for any help or advise.

Steve