Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / March 2007

Tip: Looking for answers? Try searching our database.

Copy a table into a new blank db

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
XP - 10 Mar 2007 17:05 GMT
Using Office 2003 and Windows XP;

I just need to know the fastest, most direct, and expedient method of just
copying one table from one DB into a new blank DB, both are Access 2003.

The table to be copied is stand alone; i.e. no joins or connections to any
other tables.

I can do this using VBA or by manual steps, whichever is faster and most
expedient.

Thanks much in advance for your assistance.
Ofer Cohen - 10 Mar 2007 17:58 GMT
One way

1. Open the blank mdb
2. From the menu select File > Get external data > Import
3. Select the Mdb with the table, you'll get a list of tables , select the
table and OK
the table should be copied to the new mdb

Second way
1. Open the Old mdb
2. From the menu select: File > Export
3. Select the new MDB and press Ok

Signature

Good Luck
BS"D

> Using Office 2003 and Windows XP;
>
[quoted text clipped - 8 lines]
>
> Thanks much in advance for your assistance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.