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?

 

[Adrian Jansen]

You can, but its usually much better to import data into a scratch table.
Then you get a chance to fix up the inevitable errors and anomalies in the
Excel data manually first. Once you have the corrected data in a table,
then use append or update queries to put it in your working table.

Set the scratch table up with all text fields, so you have less problems
importing from Excel.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control