468,753 Members | 1,161 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,753 developers. It's quick & easy.

compare values in a column in two tables with the same format

i have two excel spreadsheets (databases!) that have more than 8000
records in them. one is the old version (A) and one is the new version
(B). the primary key (ID) is the name for all of these but the
quantity for some of their lab results have been updated. i need to find a
way to identify those records in the old database that have new column
values for "Quantity". i'd appreciate any help. thanks.
btw. i have imported the two excel files as two separate tables into
Access and identified 40 records ( IDs) that have been added to
the old database (A). now i need to compare the ones with the same
ID that have different quantity value. thanks!"
Apr 3 '08 #1
1 965
32,130 Expert Mod 16PB
If you could provide the meta-data for your tables then we can look at providing some SQL that would identify those records that need updating.
Apr 3 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by xixi | last post: by
1 post views Thread by Mark | last post: by
13 posts views Thread by scorpion53061 | last post: by
3 posts views Thread by mcolson | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.