Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 9th, 2003, 11:17 AM
Registered User
Join Date: Jul 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default copy table from one access .mdb to another

basically what i have is an access.mdb with say, 50 tables in it. i need to create another database with say 23 of the tables from the original database.

so far, i have created a page that first renames the current database with the current date to be kept as a backup. then i have a new empty .mdb file created.

now i have my source .mdb, a copy of my previous destination .mdb, and a brand new blank .mdb with the proper name waiting for tables from the source .mdb.

any suggestions on how to get only the tables i need from the source .mdb into the new blank .mdb???

any help would be greatly appreciated. thanks in advance.

Old July 26th, 2003, 10:03 AM
Authorized User
Join Date: Jun 2003
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to vinyl-junkie

You're getting a little (ok, a lot) out of my area of expertise on just how you do this, but I'll throw something out for you. I know you can export and import an Access database to Excel. Why not export your database to Excel, get rid of the stuff you don't need from it there, then import it into your new database? Seems to me like that would work. What do you think?

Pat Wong
http://www.napathon.net/ - Music Around The World
For collecting tips, trade and want lists, album reviews and more.
Old July 26th, 2003, 05:22 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

Hi Jim,

Can you simply:

1. File > Get External Data > Import
2. Select your source .mdb
3. Select the tables you want from the Import Objects dialog


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy table from one access database to another acc fabdulla SQL Language 5 November 21st, 2007 11:13 AM
Copy of IceCream.mdb dezmond2 BOOK: Beginning Access VBA 2 July 5th, 2007 04:02 PM
Access MDB with a Linked SQL Server Table..... timmaher Classic ASP Databases 0 September 28th, 2005 03:57 AM
copy and append records from table-A to table B bhunter Access 6 March 9th, 2004 02:02 PM
Copy Data from Access.mdb into an Excel Spreadshee KennethMungwira ADO.NET 2 January 23rd, 2004 10:46 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.