Basic Append Query Question

[Scott2112]

Hi all,

I have a spreadsheet that contains PC replated information, such as hostname, last logon date, last user login, BIOS date etc.

I imported the spreadsheet into Access 2007 making the hostname field as my primary key. This is my master table.

A couple of weeks later, I receive an updated spreadsheet, with the same column headings, but some information may be different than my first spreadsheet (e.g. last logon date, or last user login).

I imported this spreadsheet into Access but a different table. Again, using the hostname as the primary key. Call this Updates Table.

I want to append anything from the Updates table to my Master Table.

My question is about existing records in the Master table- Will the records in the master table be updated with information from the Updates Table even though the records are not added to the master table?

I know it won't duplicate hostnames (primary key), but are the other columns of the record (such as last logon date, last user login) updated when using an append query?

Any help is greatly apprciated!

Regards,

Scott

 

[Galaxiom]

New records will be appended if you use an update query with an outer join from the new data to the old data.

 

[Scott2112]

Thanks for the response Galaxiom,
That is something I will have to look into. You gave me a new approach...
My databases are fairly simple, I will have to look into the outer join relationship.

Scott

 

[Scott2112]

I understand your answer better now, that I did some homework.

Won't the query you suggested only be limited to new records?

I also want to update the records in the original table with the data from the new table.

Thank you for the help!

 

[Galaxiom]

If it is just to add new records and ignore changes the Where clause is like:

WHERE PermanentTable.ID Is Null

Otherwise it will updates the old records too.

 

[Scott2112]

Thank you, I'll give it a try!

Regards,

Scott