MS Access bods

[Bailo]

I've barely ever used Access, so I was wondering - I have a big list of data, List A, with various further columns of data, in Excel. I also have List B in Excel, which links to List A through a unique ID, but has an updated column within it that I want to copy and replace the equivalent in List A, but only for the unique IDs present in List A. So:

 

1) Can I do it in Excel?

2) If not, can I load them both into Access and effectively combine these two lists?

 

and if so

 

3) How?!

 

Cheers!

[Bailo]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Zoob]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[fyds]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited March 9, 2007 by fyds

[Guest DanTheDaggerman]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Zoob]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here