Compare data across two copies of same database?

P

Pat Dools

Hello,

My statistical people (they use SAS) want to know if there is a method of
comparing the data in two different copies of the same Access database to
ensure that none of it has changed. Our process currently is to enter the
data into Access and export it into SAS for further statistical analysis.
What they want is to be able to re-import it back into a new copy of the
database and compare the data between the two copies of the database to
ensure that none of it has changed. Is there a way to compare the data? SAS
can do this via the 'PROC COMPARE' function whenever they want to compare two
copies of the same data set. Is there a similar capability in Access?

Thx, Patrick
 
J

Jeff C

You could export the data from SAS into a delimited file, import the file
into a separate table in the appropriate database. Then put both tables into
a query. relate an approptiate field from both and under the join properties
select all from one and matching from the other, then pull the fields into
the query labeling them field 1 and field two. If there are unmatched fields
they will show up.
 
Top