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.?
Printable View
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.?
Hope this query will work for U
Connection.Execute "INSERT INTO Table2(Field1,Field2,Field2) Select Field1,Field2,Field3 From Table1"
i want to insert entire table do not specify fields, what should be query for entire table copy into other table.
Change the query to
Connection.Execute "INSERT INTO Table2 Selec * Table1"