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

hi there.. you need the sql for what?? because that sql should work...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========