Adding data to an existing table

[dksj67 via AccessMonster.com]

Hello,

I would like to add data to existing records in an existing table from an
Excel worksheet. For example I have an Access record with a "Panel Name"
field value LP-A(162) and an empty "Building Number" field. I have an Excel
spreadsheet with a "Panel Name" field value of LP-A(162) with a "Building
Number" field of B361. I need an update query to find matching "Panel Name"
field values and then update the "Building Number" field value in Access.
Basically I want the query to go through each record in the Access table,
look up the matching "Panel Name" value in the Excel sheet and update the
"Building Number" field from the Excel sheet to the Access table. Can this be
done? I thought of using an append query but then I would have multiple
records of the same Panel Name in the Access table and would have to go and
search and delete the correct records.

Dan Kreiling

 

[Klatuu]

You would use an Update query.
Link to the Excel sheet as as table.
Join the Access table and the Excel table on Panel Name fields.
In the Update to for the Access Building number, use the Excel building
number field.

 

[dksj67 via AccessMonster.com]

Very good, thanks for your assistance

Hello,

I would like to add data to existing records in an existing table from an
Excel worksheet. For example I have an Access record with a "Panel Name"
field value LP-A(162) and an empty "Building Number" field. I have an Excel
spreadsheet with a "Panel Name" field value of LP-A(162) with a "Building
Number" field of B361. I need an update query to find matching "Panel Name"
field values and then update the "Building Number" field value in Access.
Basically I want the query to go through each record in the Access table,
look up the matching "Panel Name" value in the Excel sheet and update the
"Building Number" field from the Excel sheet to the Access table. Can this be
done? I thought of using an append query but then I would have multiple
records of the same Panel Name in the Access table and would have to go and
search and delete the correct records.

Dan Kreiling