
Copying Tables from one Database to another
Hi,
If you want to do it using two connection, then thre is no
easy way to do that. But you can do it using one
connection. Here is an example
Dim loConnection As ADODB.Connection
Set loConnection = New ADODB.Connection
loConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source='C:\DestinationDatabase.mdb';"
lcSQL = "INSERT INTO tblFields SELECT * FROM "
lcSQL = lcSQL & "[C:\SourceDatabase.mdb].[tblFields]"
loConnection.Execute lcSQL, , adExecuteNoRecords
loConnection.Close
Set loConnection = Nothing
Val
Quote:
>-----Original Message-----
>Hello,
>Is there a quick way with ADO to copy a table from one
connection source to
Quote:
>another one? Both connections are to Access Databases.
>Thanks, Michael
>.