Append table in external DB

[tomwp]

Hi, I need to append a table in an external db with the records in my current db using VB.

Both tables have the same structure.

Not sure how to do this, any help would be appreciated.

 

[sxschech]

You don't really need vb to do this. You can create a query and then in vb docmd.openquery

Here is an example of taking data from a table in the current file and appending it to a table in another file:

INSERT INTO tblTable IN 'C:\Documents and Settings\My Documents\External.mdb'
SELECT *
FROM tblTable;
[code]

You would change tblTable to the name of your local table and if the name of the table is different in the external mdb, then you would change that tblTable name too.