Importing data from a csv file

[Guest]

Hi

I have recently had to add a new field to a FIRM table in our contact
database, Firm.PhoneNumber (please don't ask why it wasn't there before!).
The primary key in this table is Firm.FirmID.

I have a list available to me in .csv format that contains all the phone
numbers I need, it has two 'columns', labelled FirmID and PhoneNumber.

The process is surely a simple one, I just need to update/copy/insert the
corresponding phone numbers from the csv file into the Firm.PhoneNumber
field. I won't bore you with what I've attempted thus far but could someone
please provide me with the quickest possbile method for achieving this task?
My experiments, reading and forum searches have, very surprisingly!, proved
fruitless.

Many thanks

 

[Ken Snell \(MVP\)]

Import the .csv file into a new table, using the TransferText action.

Then use an update query to get the data from the new table and write it
into the records in the existing table, using the FirmID as the linking
field.