Importing a MS Access table from one database to another via code

[Catrina]

I am using VB 6.0 with an Access 2000 database. I am most familiar with ADO. Is there a way to import or copy a table from an Access database into a different Access database? I need the complete table, data and all. I know how to create a table and copy the data from one recordset to another, but not to import an existing complete table (if possible). Thanks in advance.

Catrina

[dfwade]

You can use a SQL Query to do this
INSERT INTO MyTable IN 'd:\data\biblio.mdb' SELECT * FROM tblApplication

This will select all the data from tblApplication and instert it into MyTable in another database