Nick,
just simply want to merge new data into existing table. When new data is moved in..a temp table is created(same format) and I need to add this new information to the end of the existing table.... This is the code I've been trying to make work.

INSERT INTO cfile(Orig_lata, Term_lata, Bill_dur);
VALUE (temp.Orig_lata, temp.Term_lata,temp.Bill_dur)
appreciate any advise you have...thanks
Kelly