update just certain fields in a table

B

Bruu

I import a CSV file into my database but when I try to update a table I only
want to update some of the fields. The CSV file has a list of different
fields that are some times left blank. Can anyone help me? I am using Access
2003
 
W

Wayne Morgan

Import the CSV file into a temporary table. Use an Update Query to update
the data in the current table from the temporary table. Only include the
fields in the query that you want updated. You can also specify criteria in
the query.

When you say "update" do you mean change values for records that exist or
add records? If you are wanting to add records, change the above query to an
Append Query.
 
Top