Highlighting the differences between 2 speadsheets.

[CarysW]

I have several spreadsheets that contain the data for my database. The data needed cleansing so it was sent out to the relevant people to do this. Stupidly I thought the spreadsheets would track the changes for me but have since realised that because they were emailed out and back this didn't work.

I need to see what changes have been made so I can input these into the full database data. The data sent out was a cut down version so I can't just import it in. It's not as simple as doing a lookup etc and changing the details as there are several lines of branch info for many stores that have the same account numbers. There's no one line of data where each entry is unique!

If only I had left my primary key on the spreadsheets it would be oh so easy! But in my wisdom I took all of this out to avoid confusion.

So has anyone any ideas? I have a slight feeling that Access may have a way of doing this?

 

[wiklendt]

there are many tools online that you can download and try with your files - remember, google is your friend - and also remember (for next time) that you can hide columns if you don't want your users to see them (believe me, the average user has no idea you can even do this, let alone figure out how to undo it!)

 

[wiklendt]

for example, this is the first hit i got in a google search. may it will be useful for your problem.

 

[CarysW]

- and also remember (for next time) that you can hide columns if you don't want your users to see them (believe me, the average user has no idea you can even do this, let alone figure out how to undo it!)

Oh yes, hindsight is a wonderful thing! I'm not sure what I was thinking when I cut it down so much......

 

[CarysW]

for example, this is the first hit i got in a google search. may it will be useful for your problem.

Thakyou very much! Will give it a go.