Add New Fields and Then Update Existing Records

[Mark Schnell]

I am supplied with a monthly text-delimited data file of
new records that I import into an existing data base.
Each record in teh data base contains a unique ID number
field. At my request, subsequent reports will include
additional data fields.

In addition to the expanded report format, I have received
a text-delimited file containing the unique ID numbers
from the older records with the corresponding new field
data.

I have added the new fields to my data base. How do I
append these additional data fields into my existing data
base?

Thanks, Mark

 

[Van T. Dinh]

You can link your delimited text file, especially CSV as a linked Table to
your database then you can use an Update Query to update the blank/Null
values of the new Field of your existing Table with the values from your
linked Table.

Alternatively, you can import the file to a temporary Table and use the same
Update Query.

Once you finish the update, you can delete the linked or temporary Table as
appropriate.