Import database objects from another Microsoft Access database or Microsoft Access project
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Open the database or switch to the Database window for the open database.
On the File menu, point to Get External Data, and then click Import.
In the Files Of Type box, make sure Microsoft Access (*.mdb;*.adp;*.mdw;*.mda;*.mde;*.ade) is selected.
Click the arrow to the right of the Look In box, select the drive and folder where the Microsoft Access database (.mdb) or Microsoft Access project (.adp) that you want to import from is located, and then double-click the database's icon.
In the Import Objects dialog box, click the tab for the kind of object that you want to import, and then click each object that you want to import, or click Select All to import all objects of the desired type. Repeat this step for each kind of object that you want to import.
If you want to import just the tables' definitions (not the datathat they contain), click Options, and thenunder Import Tables, click Definition Only.
In an Access database, if you're importing select queries, and you want to import them as tables (for example, to create a read-only database), click Options, and thenunder Import Queries, click As Tables. Action queries import as queries no matter how this option is set.
If you want to include relationships (Access database only), custom menus and toolbars, or import/export specifications (Access database only), click Options, and then, under Import, select the items you want included. Microsoft Access won't import a toolbar, menu bar, or shortcut menu if it has the same name as one in the Access database or Access project that you're importing to.
Notes
You cannot import views, stored procedures, or database diagrams from an Access project to an Access database. You cannot import queries or relationships from an Access database to an Access project.
When you import a data access page, you are only importing the link to the corresponding HTML file. The HTML file remains in the same location, which means that you have two pages pointing to the same corresponding HTML file. If you don't want this, save one of the pages under a different name (using the Save As command on the File menu), enter a different file location for the new corresponding HTML file in the Save As Data Access Page dialog box, and then delete the page that you just saved.
When you import an object from another database, you may also want to import related objects to make it work. For example, a report may have a query as a record source, and that query may be based on a relationship between two tables.
Although you can import tables from an Access project to an Access database, you may find it more efficient to import the table from Microsoft SQL Server. If you are importing tables from one Access project to another, consider using Data Transformation Services (DTS), which can be a faster and more flexible way to import and transform data. For more information, see the Microsoft SQL Server documentation.
When you import a table into an Access project, Microsoft Access only imports the table data and data definitions, not its properties, including constraints, relationships, and indexes.
Although you normally use the Convert Database command on the Database Utilities submenu of the Tools menu to convert a prior version of a Microsoft Access database, you can also convert a prior version by importing its database objects. This is useful if you only need to convert some of the database objects, or if you want to automate the conversion process in Visual Basic by using the and methods.