Importing Data to Update Existing Records

[Frank]

Is it possible to import data from an Excel spreadsheet
into an existing Table and have the data populate in a
field on existing records?

For example, I have a database that contains Customer
information and I want to add a new field to the Customer
table called "Hierarchy Node". Each customer will have
it's own unique value within this Hierarchy Node field,
but I don't want to have to manually enter each one on
every single Customer record. How can I use the Import
function to automatically populate these values for each
record?

<I apologize for posting this in two different message
boards. I didn't realize it until after I posted this in
the Tables & Database Design forum that I put it in the
wrong board>

 

[Kevin11]

If I understand correctly your Excel document has a column
for Customer and a Column for Node and your Access table
has a field for customer and a bunch of other fields.

Import or Link your Excel document. Verify the Excel
field names for both the Customer and Node. Link the
Customer field in the Excel table with the Customer field
in your regular Access table. Create a query with all the
fields from your regular Access table and the Node field
from the Excel table. Your query will have all the record
information you need and can be sourced by your
forms/reports or used to generate a new table.

Kevin11

 

[Guest]

Thanks a million. Worked like a charm.

-----Original Message-----
If I understand correctly your Excel document has a column
for Customer and a Column for Node and your Access table
has a field for customer and a bunch of other fields.

Import or Link your Excel document. Verify the Excel
field names for both the Customer and Node. Link the
Customer field in the Excel table with the Customer field
in your regular Access table. Create a query with all the
fields from your regular Access table and the Node field
from the Excel table. Your query will have all the record
information you need and can be sourced by your
forms/reports or used to generate a new table.

Kevin11

.