Update/Append Access 2000 Tables

[Guest]

I have an Access 2000 table that needs to be updated with a DBF file using
the SSN field from both tables. Paradox had an Append & Update option that
created temporary "CHANGED" and "KEYVIOL" tables. That is, records in either
the "TO" or "FROM" tables that do not match the key are put in a "CHANGED"
and "KEYVIOL" tables.

That being said, I want to know the specific records in DBF file that are
not in the Access table and vice versa. And, I want to have those records in
separate tables.

I want to create a table from the Access table of records that do match the
SSN field in the DBF file. I also want to create a table from the DBF file
of records that do match the SSN field in the Access table. I want to have
these tables before I update or append.

Thanks,

 

[MacDermott]

If you create a link to the DBF file, you can use queries to extract the
information you want.
A simple INNER JOIN on the SSN will show which records exist in both tables.
Access also has a "Find unmatched" query wizard which will build you a query
to find the records in the DBF file which are not in the Access table.

HTH
- Turtle