Need advice on updating and importing

Hello all,

I am a new user on Access, and have run into a jam with a requirement. I am bringing information in from another source and runing reports and queries. One of the requirements is to have a update table and a permanent table. When the information comes into the update table, it needs to be able to look at the permanent table and update any information that has changed or is different. This could be in the form of new data, or it could just be status changes in current data. It does not matter if the information that is the same for the records would have to be overwritten since it would be the same anyway. Does anyone have a good idea of how I might want to go about this. I appreciate any help on the subject, since I have hit a major road block. Thanks!!!

re: Need advice on updating and importing

what is the other source where you are bringing data in from?

re: Need advice on updating and importing

it will be coming in from and excel table

re: Need advice on updating and importing

Do you have your spread sheets directly linked into access?

You can link a single sheet to access and it acts like a table, where any information that you change in access will be changed into excel and vis versa.