Hi guys i need help i want to move the existing data from table 1 into table 2 how i need to write the query. I tried the select into statement but it did not work at all. So how to do it . Please help i doing this on the vb6 programming
Jump to Post
SELECT INTO Table2 (Field1, Field2, Field3) SELECT Table1.Field1, Table1.Field2, Table1.Field3 FROM Table1
As table2 already exists.
All 6 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.