Please, read my comment to the question first!
If you want to copy ms access database file from one location into another, please use
File.Copy()[
^] method.
If you would like to copy data between existing databases, you need to connect to destination database (for example:
C:\DMT.net\mdb\Edata2.mdb
) and use sql command like that:
INSERT INTO DestinationTableName (Field1, Field2, Field3,..., FieldN)
SELECT Field1, Field2, Field3,..., FieldN
FROM SourceTableName IN 'C:\DMT.net\mdb\Edata1.mdb'
Note: In a destination database destination table must exists!
For further information, please see:
IN Clause - MS Access[
^]
Accessing external data using the IN clause[
^]
But if you would like to copy data into new (empty) database, you need to:
- create it first[^]
- copy data as is shown above using make table query[^]
More:
Tips and Techniques for Queries in Access 2007[
^]