Need vb script/macro to append table in access database A to datab

T

Toast

Need vb script or macro to append a table in access database A to table of
the same name in access database B
 
D

Douglas J. Steele

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.

Ask a Question

Top