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 from a Database Program

All the database programs that Access supports imports from (FoxPro, Paradox, and dBase) have file formats that are similar enough to Access that there's no fuss.

After you click on Import (step 5 in the previous procedure), Access takes a moment, then displays a message like Successfully imported file name. That's all there is to it; the imported table appears on the Tables tab of your database.

Importing from a Spreadsheet

If you followed the preceding procedure for a spreadsheet file, the Import Spreadsheet Wizard opens next, as shown in Figure 29.2.

Follow these steps to finish the import:

  1. At the first Import Spreadsheet Wizard screen, click on the worksheet you want to import, if there is more than ...

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