I posted this question in the general forum, but after a bit of research I realized that i shuold direct my question towards this section simply because i believe i can solve my problem using queries.

The situation is this, i have one table that i exported from sharepoint that contains various bits of information regarding our servers.

The second list is one that was given to me that contains additional information that needs to be added to the first table.

There is a bit of overlap in the information (there is a column for hostnames which are the same on both tables)

Basically I need to add the additional information from the second table into the first, but they need to correspond with the correct servers.

This really my first time using access, and i'm a bit confused on how to use the append query to do this task. I know it needs to find all the entries with the same hostname, then append the additional information into the fields that i added.

Any suggestions?

I posted this question in the general forum, but after a bit of research I realized that i shuold direct my question towards this section simply because i believe i can solve my problem using queries.

The situation is this, i have one table that i exported from sharepoint that contains various bits of information regarding our servers.

The second list is one that was given to me that contains additional information that needs to be added to the first table.

There is a bit of overlap in the information (there is a column for hostnames which are the same on both tables)

Basically I need to add the additional information from the second table into the first, but they need to correspond with the correct servers.

This really my first time using access, and i'm a bit confused on how to use the append query to do this task. I know it needs to find all the entries with the same hostname, then append the additional information into the fields that i added.

Any suggestions?

Since what you want to do is Append rows to a table, then an Append Query should work. Use the query wizard, select the two tables, drag and drop the connecting column, and add any conditions

Since what you want to do is Append rows to a table, then an Append Query should work. Use the query wizard, select the two tables, drag and drop the connecting column, and add any conditions


Could you maybe elaborate a bit further? I'm unable to get any results :(