Create table in new database from existing databse [RESOLVED]

[satyarao]

Hi,

I am working with Ms-Access2000, with VB6.
I am having two identical database in two different folders with same name, and identical table name with similar structures.

eg:
1. D:\ABC\Fabric.mdb

2. D:\NEW\Fabric.mdb

the first data base consists of data, where as second one consists of empty tables...

Here... I want to dump the data of selected tables of ABC folder's Fabric database to NEW folder's Fabric database.

I thought of 2 ways....

1) first reading the data of table1 and using INSERT command putting each record to NEW folder's Fabric database...
(like this i have to go on reading the records... from selected tables and put in the correspoinding table1 in NEW folder's Fabric database)

2) Deleting the 'table1' from NEW folder's Fabric database... and simply copy the 'table1' from ABC folder to NEW folder...


in the second model i am not clear that how to copy an existing table from on database to another database.
or
is there any way to create new table in required (NEW) database from existing database(ABC)... (like in Oracle Create table emp1 as(Select * from EMP)).... in this case first CREATE part should be done in NEW database... and SELECT part should be done at ABC database...

please help me....

thanks in advance...