Import text file and update table

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have to import a text file daily and I want update
records in an existing table with changed values and
append to the same table the new records on the text
file. Can the update and append actions be done at the
same time the file is imported or do I have to create a
separate table for the raw imported data and update the
existing table from the new table using a query?

Thanks!
 
Rick said:
I have to import a text file daily and I want update
records in an existing table with changed values and
append to the same table the new records on the text
file. Can the update and append actions be done at the
same time the file is imported or do I have to create a
separate table for the raw imported data and update the
existing table from the new table using a query?

Thanks!
Click to expand...

You cannot update and append in one action anyway. Append can be done
with import by using the wizard (cannot find VBA equivalent, though) but
I think you best stick with the intermediate table here.
 
Back
Top