Advertisements

Import Access 2.0 and Access 95 databases into current versions

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007.

If you use a current database in the Access 2.0 format (.mdb), or the Access 95 format (.mdb) in some cases you can import tables, queries, and macros from that database into a latest version of Access that uses the .accdb file format.

To import forms and reports that embody VBA code (and also modules), start by converting your Access 2.0 or Access 95 database to the Access 2002 – 2003 or Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or Access 2000. You can then employ a more recent version such as Access 2007 to convert that file to the .accdb file format which can then be accessed by Access 2010, Access 2013, or Access 2016

The following sections in this article explain how to run these tasks.

Are you using Access 2010, Access 2013, or Access 2016?

Access 2007 was the final version to complement opening, importing, linking or exporting to Access 2.0 and Access 95. You must have Access 2007 before managing to export, import or link data from Access 1.0 and 2.0 (Red 2, or Jet 2) files and Access 95 databases. In this case, you must use Access 2007 as an intermediary step to completely convert an Access 2.0 database to one of these versions.

What do you want to do?

Open an Access 2.0 database in Access 2007

Import data from an Access 2.0 database into Access 2007

Import data from an Access 95 database into Access 2007

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

Open an Access 2.0 database in Access 2007

Once you open an Access 2.0 database in Access 2007, Access lists multiple prompts that, when followed, end with the message This database was saved in the Microsoft Access 2.0 file format.

This database was saved in the Microsoft Access 2.0 file format.

You can import tables, queries, and macros from an Access 2.0 database into an Access 2007 database (.accdb). To import forms, reports, or modules into an Access 2007 database, you start converting the database by using an previous version of Access, then enter the converted database by using Access 2007, and then convert the database into an Access 2007 .accdb file format database. See the section Convert an Access 2.0 or Access 95 database by using Access 2003, Access 2002, or Access 2000 for more information.

Import data from an Access 2.0 database into Access 2007

After you import objects from another database, duplicates of the objects that you import are formed in the destination database. The source remains intact. To import data from an Access 2.0 database into Access 2007, you begin by opening the database that you want to import the data into. You then use commands on the External Data tab to continue with the import process, which comprises invoking the Import Wizard.

  1. Launch Access 2007, pick the Microsoft Office Button, and then choose Open.
  1. In the Open dialogue box, pick and and enter the database that you want to import the tables, queries, or macros into.
  1. On the External Data tab, in the Import group, select Access.
  1. In the File name text box of the Get External Data Wizard, state the name of the source database, or press Browse to raise the File Open dialogue box and then select or input the name of the source database.
  1. Select Import tables, queries, forms, reports, macros, and modules into the current database, and then choose OK.
  1. In the Import Objects dialogue box, select each tab and pick your desired objects. Remember that you can only import tables, queries, and macros from an Access 2.0 database into Access 2007.Import Objects dialog box To cancel a picked object, select the object again.
  1. Press Options to confirm extra settings. The following table outlines how each option impacts the results of the operation.
ElementDescription
Relationships check boxImports the relationships between the selected tables.
Menus and Toolbars check boxImports 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 boxImports any saved import or export specifications that exist in the source database.
Nav Pane Groups check boxImports any custom Navigation Pane groups that exist in the source database.
Definition and Data buttonImports the structure and data of all selected tables.
Definition Only buttonImports only the fields in the selected tables. The source records are not imported.
As Queries buttonImports the selected queries as queries. In this case, remember to import all the underlying tables along with the queries.
As Tables buttonImports queries as tables. In this case, you need not import the underlying tables.
  1. Press OK to finish the operation. Access relays the data and shows error messages if it runs into any problems. If the operation accomplishes the data import, the final page of the wizard enables you to save the details of the operation as an import specification for future use.

Import data from an Access 95 database into Access 2007

To import data from an Access 95 database into Access 2007, 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.

You can import tables, queries, and macros from an Access 95 format (.mdb) database into an 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 .accdb file format.

  1. Launch Access 2007, pick the Microsoft Office Button, and then choose Open.
  1. In the Open dialogue box, pick and access the database that you want to import the tables, queries, or macros into.
  1. On the External Data tab, in the Import group, press Access.
  1. In the File name box of the Get External Data Wizard, enter the name of the source database, or select Browse to showcase the File Open dialogue box and then select or type the name of the source database.
  1. Press Import tables, queries, forms, reports, macros, and modules into the current database and then choose OK.
  1. In the Import Objects dialogue box, select each tab and click the objects that you want to import. To cancel the specified object(s), press the object again.
  1. Press Options to specify further settings. These advanced settings will display in groups below the list of objects.
  1. Select OK to finish the operation. Access duplicates the data and presents error messages if it experiences any problems. If the operation successfully imports the data, the final page of the wizard lets you save the details of the operation as an import specification for future use.

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

You can convert an Access 2.0 database to the Access 2000 or Access 2002 – 2003 file format by applying one of the versions of Access listed in the following table, given that you bought that version of Access and installed it on your computer. Based on your version of Access, the Access 2.0 converter should already be installed.

VersionAccess 2.0 Converter
Microsoft Office Access 2003This version mandates downloading and installing the Access 2.0 Converter for Access 2003. However, this tool is unavailable from Microsoft Download Centre because Access 2003 has stopped receiving extended support.
Microsoft Access 2002Built-in with the product.
Microsoft Access 2000Built-in with the product.

You should convert the Access 2.0 or Access 95 file to the Access 2000 or Access 2002 – 2003 .mdb file format. You can then use Access 2007 to convert the created file to the Access 2007 .accdb file format. You can then employ the database in Access 2007 or launch it in Access 2010, Access 2013, or Access 2016. According to on your earlier version of Access, take the following steps:

  1. Open Access 2003, Access 2002, or Access 2000.
  1. On the File menu, pick Open, and then select the file name for the desired Access 95 database to convert.
  1. On the Tools menu, select Database Utlities, pick Convert Database, and then choose To Access 2000 File Format.
  1. In the Convert Database Into dialogue box, type a filename for the new file, and then press Save. You may see an informational message warning that you are unable to use the converted database in earlier versions of Access. If this message appears, select OK. The file is saved in the Access 2000 file format.
  1. Launch Access 2007.

  1. Press the Microsoft Office Button, and then choose Open.
  1. In the Open dialogue box, pick and access the converted database.
  1. Select the Microsoft Office Button, and then choose Convert.
  1. In the Save As dialogue box, state a filename for the Access 2007 file, or accept the pre-populated file name, and then select Save. The file is saved in the Access 2007 .accdb file format.

Top of Page

Advertisements

Leave a Reply

%d bloggers like this: