DaniWeb Forum Index > Web Development > ASP

Copying table from one mdb to another

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2003

Posts: 4

Reputation: yourmna is an unknown quantity at this point

Solved Threads: 0

yourmna

Offline

Newbie Poster

Copying table from one mdb to another

Mar 17th, 2004

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?

•

Join Date: Apr 2004

Posts: 167

Reputation: Drew is an unknown quantity at this point

Solved Threads: 7

Drew

Offline

Junior Poster

Re: Copying table from one mdb to another

Apr 5th, 2004

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.