Daily imported data to table for modifying.

[Ken_Spc]

I'm pretty new to Access but I have a database in which data will be imported daily (From a text file) to a table to track daily shipments. I want to add two more columns to the table it's imported to to manually type in how many products were shipped so far and to calculate how many are still due through a form. Maybe I'm going about this the wrong way, but every time I import the new data, the new columns are overwritten. I have tried a linked table to the text file and have that info copied to another table, which had the two new columns in it, using an update query but with the same results. I hope this makes sense and someone can help.


Tbl1 (Imported)


Order number, Customer name, Item, Qty Ordered

Tbl2
Qty shipped, Bal Due

Combine 2 tables to track Qty shipped and what's still due. And also to keep the information the next day when next text file is imported.

Thanks in advance

[CJ_London]

I hope this makes sense

only that it implies there is something wrong with your code - please supply the code if you want some help.

Best I can think is you are using a make table not an append query