hi, I would really appreciate it if someone could help me with this. I know that copying data from one table into another table is pretty easy to do. But i can't figure out how to to copy data from one table to another, but also including some values that aren't in the original table. I'm wondering if it is possible to do it with a single sql statement. And fyi, i'm a newbie with asp.net vb.. So sorry if there are some major problems in my coding. Its my first time doing a program with vb.net. so i've pasted below my coding. can you tell me whats wrong with it? apparently when i run it, there's no error. But the data isn't transferring into the new table.