Comparing 2 files

[sharonbl]

Hi everybody!Currently, I'm doing a program with access to import 2 files and to compare them and print out the difference as well as exporting them back.However, I'm new to Access with no experience at all.I would like to know where and how do I start from? Do I need to use modules and VBA?Does anybody has a similar program and if you do have, izzit possible to send it to me as reference?
You guys' help will be greatly appreciated.

 

[Atomic Shrimp]

Depends on what you want to do, but you should be able to accomplish most of this with queries, but there are two kinds of comparison that you might end up doing:

1:Comparison of differences in a number of fields where the two tables(files) have at least one common key, you would join the two tables on the common key and then use the query criteria to select records with differing values in the other fields.

2:Find Unmatched query; here you would have to assume that one table is the 'master' and you can then pull out all of the records in the second which don't match in one or more field. You can always run a second find unmatched query using the other table as a master.

Is this any help - I can mail you a little demo if you like.

(interestingly this sounds very much like MY first access project)

Mike