Copying Tables to Another Access Database

  • Thread starter Thread starter mike
  • Start date Start date
M

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
 
The TransferDatabase method allows you to copy objects from the open
database to another database. Check it out in VBA Help.
 
Anyone know how to write in code a method to copy a table
from an open Access Database to another closed Database?
Click to expand...


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
 
Back
Top