Copying table from one mdb to another

[yourmna]

I am using ASP 3.0. I have 2 access database (mdb) files; source.mdb and destination.mdb. There is a table with the name "countries" in source.mdb and I wish to copy it in destination.mdb file with the structure and data. Can any body give the ASP code to do the same?

[Drew]

Hey yourmna,

You would have to copy and paste the table from the first database to the second one.

That would mean you would have to open each database, select the table you want, press ctrl-c, then go to the other database and press ctrl-v. Then enter the table name, and click OK. It should copy the table and fields over.

I hope this helps.