Copying Tables to Another Access Database

[mike]

Hi:

Anyone know how to write in code a method to copy a table
from an open Access Database to another closed Database?

Mike

 

[Cheryl Fischer]

The TransferDatabase method allows you to copy objects from the open
database to another database. Check it out in VBA Help.

 

[Tim Ferguson]

Anyone know how to write in code a method to copy a table
from an open Access Database to another closed Database?

append query:

INSERT INTO OtherTable IN f:\other\database.mdb
(FieldOne, FieldTwo)
SELECT Something, SomethingElse
FROM MyTable


or else maketable query:

SELECT Something, SomethingElse
INTO OtherTable IN f:\other\database.mdb
FROM MyTable

You can set up either of these in the query design grid.

Hope that helps


Tim F