• 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 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 not listed, rerun the Microsoft Office setup program and choose Custom installation, 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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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