Actually, you don't need either. All you need is a query.
Assuming the table already exists in database B, the SQL of your query would
be something like
INSERT INTO [;DATABASE=C:\Folder\File.mdb].TableName (Field1, Field2,
Field3)
SELECT Field1, Field2, Field3 FROM TableName
This query would exist in database A, where C:\Folder\File.mdb is the full
path to database B.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.