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
gingank
0
Junior Poster
Recommended Answers
Jump to PostSELECT INTO Table2 (Field1, Field2, Field3) SELECT Table1.Field1, Table1.Field2, Table1.Field3 FROM Table1
As table2 already exists.
Good Luck
Jump to PostSELECT INTO staff_badgeTracking (Field1Name) SELECT ...
You need to use the name of the field in between those parens without any single ticks ', then it should work for you.
Good Luck
All 6 Replies
vb5prgrmr
143
Posting Virtuoso
gingank
0
Junior Poster
vb5prgrmr
143
Posting Virtuoso
gingank
0
Junior Poster
vb5prgrmr
143
Posting Virtuoso
asad al
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.