Updating Tables When many fields might be different

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.

jmvassar said:
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
Click to expand...
data.
 
Back
Top