|
-
Oct 11th, 2005, 04:15 AM
#1
Thread Starter
Hyperactive Member
How to insert a table records into other table
As per title i want to insert a table's records into other table, or u can say copy records from one table to other tabel, what shoul be sql query.?
-
Oct 11th, 2005, 04:34 AM
#2
Lively Member
Re: How to insert a table records into other table
Hope this query will work for U
Connection.Execute "INSERT INTO Table2(Field1,Field2,Field2) Select Field1,Field2,Field3 From Table1"
-
Oct 11th, 2005, 04:47 AM
#3
Thread Starter
Hyperactive Member
Re: How to insert a table records into other table
i want to insert entire table do not specify fields, what should be query for entire table copy into other table.
-
Oct 11th, 2005, 04:59 AM
#4
Lively Member
Re: How to insert a table records into other table
Change the query to
Connection.Execute "INSERT INTO Table2 Selec * Table1"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote