update just certain fields in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

TYPE CONVERSION FAILURE - text to text field 3
Updating tables when you input new data 0
Count field length in delimeted file and compare with predefined listof field length 8
Need help with importing data 2
(Type mismatch in expression) Update Query - Linked Excel 4
How to import several csv files into 1 access table? 4
Type Conversion Error While Importing (Time Field) 8
regularly importing from csv 1

Back
Top