Macro to parse data and compare tables

[twckfa16]

Hello - not sure if this is in the right spot or not.



I have three files in a zip attached below - central_data, nov142014-test, and result-central_data -
all files from excel.

I need to import the central_data, and the nov14 file into access and do a comparison between the two.
The "result" file is just for illustration purposes - the central_data file will be updated in reality.

Let's just take the first record. They are identical except the Data2 column starts with 1000 in one
and 1500 in the other. For my purposes, if we ignore the numbers in front they are identical.
So the central_data file would not change.

The second record is completely identical, so the central_file would not change either.

The third record does not exist in the central_data file so it would be inserted as a new record,
dropping what was originally there to the fourth spot.

Like I said, the "result" is what the new central_data file should look like.

So....can Access loop, parse data etc...and then loop through another table and perform updates?

Sorry for being so lengthy but would help if someone could point me in the right direction.

Thank you

[ranman256]

OMG, that is a horrible way to store data.

But you dont have to import the data, you can LINK the xl tables in, then run a query.

I got DATA & NOV to match DATA.data1 to NOV.data1 join.
then
DATA.data2 to NOV.data2 join.

So you should be able to do the same.

[twckfa16]

Hi ranman -

Thank you for responding and I know its been a couple months....I understand, unfortunately that's how the data is stored.

How did you construct the joins - if you remember?

[June7]

Is the Data1 value unique in both tables? If this value is found in both tables then the Nov Data2 value should be used to replace the value in Central table?

A Find Unmatched query could identify new records.