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.