>INSERT INTO tablename(Orig_lata, Term_lata, Bill_dur);
> VALUE (temp.Orig_lata, temp.Term_lata,temp.Bill_dur)
>
>
>I'm using this code to bring information into a table from a temp table with same format....It works if I put the actual tablename in the code, but I want to be able to choose that path each time. What can I use as a generic tablename???
>Kelly
>
>
You can use Name Expression in INSERT statment
lcTableName = "MyTable"
INSERT INTO (lcTableName) (Orig_lata, Term_lata, Bill_dur);
VALUE (temp.Orig_lata, temp.Term_lata,temp.Bill_dur)
--sb--