Updating table from external file?

  • Thread starter Thread starter Jonathan Grobe
  • Start date Start date
J

Jonathan Grobe

What is the easiest way to update some of the records
in field X of a table from an external file:
Say you have a csv file with two items for each of
the records you want to update: the primary index value
and the new value for field X?

Thank you.
 
1. create a link to the csv file.
2. run an update query to update related fields.

Ed Warren
 
Hi Jonathan,

Here's one way:

1) Use File|Get External Data|Link to access the CSV file as a linked
table.

2) Create an update query which joins the linked table and the existing
table on the primary key and updates field X.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

acnewrec? 1
MS Access Avoiding redundancy 1
Using data in a CSV to update a DB 3
Need to remove leading character 6
Keeping Relational Table Current-Access 2007 8
Access Updating inventory levels 0
import data from excel 2003 to a table in an existing database 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top