Copying table from one mdb to another

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 391,802 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,429 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 7346 | Replies: 1

•

Join Date: Sep 2003

Posts: 4

Reputation: yourmna is an unknown quantity at this point

Rep Power: 0

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

Location: Springfield, Oregon

Posts: 119

Reputation: Drew is an unknown quantity at this point

Rep Power: 5

Solved Threads: 6

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.