Member Avatar for 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?

  • 2 Contributors
  • 1 Reply
  • 108 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by Drew
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.