Import text file and update table

[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!

 

[Bas Cost Budde]

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!

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.