Updating Tables When many fields might be different

[Guest]

I have tables that I had originally imported from DBase. I had to add unique
fields once in Access. Now I am trying to update with new DBase tables that
may have more or less records.

I have tried using unmatched queries but they only let me identify one
field. I need to identify multiple fields where there may be unmatched data.

 

[Alex Ivanov]

That may be easy to do if you have consistent record ids between your access
and dbase tables. In this case you can run the sql like this:
select * from accesstable as a right join linkedDBaseTable as b on
a.recordid=b.recordid
where a.field1<>b.field1 or (a.field1 is null and b.field1 is not null) or
(a.field1 is not null and b.field1 is null)
and a.field2<>b.field2 or (a.field2 is null and b.field2 is not null) or
(a.field2 is not null and b.field2 is null)
..... repeat for all fields that matter

--
Please reply to NG only. The email address is not monitored.

Alex.

I have tables that I had originally imported from DBase. I had to add unique
fields once in Access. Now I am trying to update with new DBase tables that
may have more or less records.

I have tried using unmatched queries but they only let me identify one
field. I need to identify multiple fields where there may be unmatched

data.