admin
05-30-2003, 08:21 AM
You can copy the data from one table to another table quite easily. Of course both tables must have the same field names and data types.
<%
Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Databases\main.mdb"
SQL = "Insert Into Customers2 Select * From Customers"
MyConn.Execute(SQL)
MyConn.Close
Set MyConn = Nothing
%>
<%
Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Databases\main.mdb"
SQL = "Insert Into Customers2 Select * From Customers"
MyConn.Execute(SQL)
MyConn.Close
Set MyConn = Nothing
%>