One approach is to use the IN statement. For example
INSERT INTO MyLocalTable
SELECT *
FROM MyRemoteTable
IN 'C:\MyRemoteDatabase.mdb'
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"pwh777" <pw****@hotmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
I have read many of the topics on importing tables from one database to
another. However, I don't want to use the TransferDatabase command
because I want to copy all the records (not the object) from one table
in an external database into my current database. My current database
already has the table and I want that table to keep its records.
Any ideas?