O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing Data from Other Programs

Access accepts data from a wide variety of database programs, making it very easy to switch to Access without much loss of productivity. To import data from another program, follow these steps:

  1. Open the Access database into which you want to import the data. You may want to create a new, empty database especially for this purpose (see Lesson 5).

  2. Select File, Get External Data, Import. The Import dialog box opens (see Figure 29.1).

    Figure 29.1. You can import data from a variety of sources.

  3. Open the Files of type drop-down list and select the type of file the data is coming from. If the type you want is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required