Import an Access 95 database into an Access 2007 file

If you use an existing database in the Access 95 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). You can also import forms and reports that do not employ Microsoft Visual Basic for Applications (VBA) code.

To import forms and reports that contain VBA code (and also modules), first convert your Access 95 database to the Access 2002 - 2003 or Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or Access 2000, and then use Access 2007 to convert that file to the Access 2007 file format.

What do you want to do?


Import data from an Access 95 database

When you run an operation to import data from another database, a copy of the data or objects that you import is created in the destination (Access 2007) database, and the source is not altered. To import data from an Access 95 database, you first open the Access 2007 database that you want to import the data into. You then use commands on the External Data tab, which involves invoking the Import Wizard.

 Note   You can import tables, queries, and macros from an Access 95 format (.mdb) database into an Office Access 2007 database (.accdb). You can also import forms and reports that do not use VBA code. To import forms and reports that contain VBA code (and also modules), first convert your Access 95 database to the Access 2002 - 2003 or Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or 2000, and then use Access 2007 to convert that file to the Access 2007 file format.

For more information about converting an Access 95 database by using a version of Access earlier than Access 2007, see the section Convert an Access 95 database by using Access 2003, Access 2002, or Access 2000.

  1. Click the Microsoft Office Button Button image, and then click Open.
  1. In the Open dialog box, select and open the database that you want to import the tables, queries, or macros into.
  2. On the External Data tab, in the Import group, click Access.

Button image

 Note   The External Data tab is available only when a database is open.

  1. In the File name box of the Get External Data Wizard, type the name of the source database, or click Browse to display the File Open dialog box and then choose or type the name of the source database.
  2. Click Import tables, queries, forms, reports, macros, and modules into the current database and then click OK.
  3. In the Import Objects dialog box, click each tab and select the objects that you want to import.

Import Objects dialog box

To cancel the selection of an object, click the object again.

  1. Click Options to specify additional settings. These additional settings will appear in groups below the list of objects.

The following table describes how each option impacts the results of the operation.

Element Description
Relationships check box Imports the relationships between the selected tables.
Menus and Toolbars check box Imports any custom menus and toolbars that exist in the source database. The menus and toolbars are displayed on a tab named Add-Ins.
Import/Export Specs check box Imports any saved import or export specifications that exist in the source database.
Nav Pane Groups check box Imports any custom Navigation Pane groups that exist in the source database.
Definition and Data button Imports the structure and data of all selected tables.
Definition Only button Imports only the fields in the selected tables. The source records are not imported.
As Queries button Imports the selected queries as queries. In this case, remember to import all the underlying tables along with the queries.
As Tables button Imports queries as tables. In this case, you do not need to import the underlying tables.
  1. Click OK to finish the operation.

Access copies the data and displays error messages if it encounters any problems. If the operation succeeds in importing the data, the final page of the wizard allows you to save the details of the operation as an import specification for future use. The following section explains how to save the operation details as a specification.

Save the import specification

You can save the details of the import operation as an import specification so that you can repeat the operation at a later time without having to reenter the information in the wizard. As an additional option, you can create a task in Microsoft Office Outlook 2007 to remind you to run the import specification. For added convenience, the Office Outlook 2007 task that you create contains a button that you can use to run the operation without opening the Access database. To use this feature, Office Outlook 2007 must be installed and configured on your computer.

  1. Click Save import steps to save the details of the operation.
  2. In the Save as box, type a name for the import specification. Optionally, type a description in the Description box.
  3. Select the Create Outlook Task check box if you want to perform the operation at fixed intervals, such as weekly or monthly.

This creates an Office Outlook 2007 task that lets you run the specification.

  1. Click Save Import.

If you did not select the Create Outlook Task check box, Access saves the import specification and imports the objects that you specified. You can now review the imported tables and other objects to ensure that they were imported correctly.

If you selected the Create Outlook Task check box, and Outlook is installed and configured on your computer, Access starts Outlook. Use this procedure to complete the steps that follow.

 Note   If Outlook is not installed, Access displays an error message. If Outlook is not configured properly, the Outlook Startup Wizard starts. Follow the instructions in the wizard to configure Outlook.

  1. In Outlook, review and modify the task settings, such as Due date and Reminder.

To make the task recur, click Recurrence. This figure shows the task scheduler with some typical settings.

Outlook task scheduler

For more information about scheduling an import operation, click the link in the See Also section of this article.

  1. Click Save and Close.

To run the specification at a later date, open the task in Outlook and, on the Task tab, in the Microsoft Office Access group, click Run Import Button image.

  1. In Access, review the imported tables and other objects to ensure that all the data and objects were copied.

Top of Page Top of Page

Convert an Access 95 database by using Access 2003, Access 2002, or Access 2000

You can convert an Access 95 (.mdb file format) database to the Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or Access 2000. You can then use Access 2007 to convert the resulting file to the Access 2007 file format. To convert an Access 95 database to the Access 2000 file format by using another version of Access, do the following:

  1. Start Access 2003, Access 2002, or Access 2000.
  2. On the File menu, click Open, and then click the file name for the Access 95 database that you want to convert.
  3. On the Tools menu, click Database Utilities, click Convert Database, and then click To Access 2000 File Format.
  4. In the Convert Database Into dialog box, enter a filename for the new file, and then click Save.

You might see an informational message warning that you will not be able to use the converted database in earlier versions of Access. If this message appears, click OK.

The file is saved in the Access 2000 file format.

  1. Start Access 2007.
  2. Click the Microsoft Office Button Button image, and then click Open.
  1. In the Open dialog box, select and open the converted database.
  2. Click the Microsoft Office Button Button image, and then click Convert.
  3. In the Save As dialog box, enter a filename for the Access 2007 file, or accept the file name that is provided, and then click Save.

The file is saved in the Access 2007 file format.

Top of Page Top of Page

 
 
Applies to:
Access 2007