• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 29. Importing and Exporting Data > Importing Data from Other Programs

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 might want to create a new, empty database especially for this purpose (see Lesson 5).

  2. Choose 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 isn't listed, rerun the Microsoft Office setup program and install the import/export filter you need.

  4. Change the drive or folder to the one where the file is stored. The file's name appears in the list box in the middle of the dialog box.

    Caution

    It's Not There! If the file name doesn't appear in the list box, either you are in the wrong folder or drive, or you have selected the wrong file type.


  5. Double-click the filename, or click it and then click Import.

    Various things might happen next, depending on what type of file you're importing from. See the following sections.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint