hi
   in vb i want to create a table and then i want to insert the data from some other table


if am using access db means i can use the below code
dbconn.Execute "SELECT * into Tab_Add_Ach_qty FROM Add_Ach_qty"

i dont the corresponding code 4 sql db

pls do the needful
thanks in AAdvance