Maintaining up to date database with imported/appended information

[Angie333]

Hi Everyone,
Hoping someone can help. Our database is used to track our website usage. Each viewer that we track can maintain their subscription to the web site through an outside database and therefore update their profile.

Each week we download this data from and import into Access that gives information on what each viewer did.

We have a seperate table set of as a viewers table (much like a contact database). We use a primary key on the email address as the identifier. The problem is that since a viewer can update their profile information on the web, when i download and then append the new stats into Access - it will add any new viewers found to create a complete table of viewers - BUT not UPDATE the viewers profile information if it was changed.

Is there any way to append or input new records that will not only include NEW records but ALSO overwrite any existing records with the latest information based on that primary key?

Hoping this makes sense. Any help would be appreciated.

Thanks :)

[puppydogbuddy]

Hi Everyone,
Hoping someone can help. Our database is used to track our website usage. Each viewer that we track can maintain their subscription to the web site through an outside database and therefore update their profile.

Each week we download this data from and import into Access that gives information on what each viewer did.

We have a seperate table set of as a viewers table (much like a contact database). We use a primary key on the email address as the identifier. The problem is that since a viewer can update their profile information on the web, when i download and then append the new stats into Access - it will add any new viewers found to create a complete table of viewers - BUT not UPDATE the viewers profile information if it was changed.

Is there any way to append or input new records that will not only include NEW records but ALSO overwrite any existing records with the latest information based on that primary key?

Hoping this makes sense. Any help would be appreciated.

Thanks :)

Angie333

Ordinarily, you would have create and run two separate queries (update/append) on the data source. Your update query would update the table(s) for transaction data affecting existing records, while an append query would insert transaction data representing new records. The only way you can append and update records in a single update query is if the table(s) have a unique index that does not contain the AutoNumber data type for all or part of the index..See the following link for details:

http://support.microsoft.com/kb/208870

[Angie333]

Angie333

Ordinarily, you would have create and run two separate queries (update/append) on the data source. Your update query would update the table(s) for transaction data affecting existing records, while an append query would insert transaction data representing new records. The only way you can append and update records in a single update query is if the table(s) have a unique index that does not contain the AutoNumber data type for all or part of the index..See the following link for details:

http://support.microsoft.com/kb/208870

Thank you so much for the help! Your answer was just what i was looking for! Worked perfectly! Have a Happy Fourth of July! :)

Thanks again - Angie

[puppydogbuddy]

Thank you so much for the help! Your answer was just what i was looking for! Worked perfectly! Have a Happy Fourth of July! :)

Thanks again - Angie

You are very welcome. Glad I could help. Have a happy and safe Fourth of July, also.