Is there a quick way with ADO to copy a table from one connection source to
another one?  Both connections are to Access Databases.

Thanks,  Michael

INSERT INTO myTable
SELECT * FROM myTable IN 'c:\myother.mdb'

--
Michael Collier Bsc (Hons)

Interactive ADO Browser www.adoanywhere.com
Free ADO Browser (FAB)  www.adoanywhere.com/fab
Home Page www.adoanywhere.com

--

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