O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

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

Chapter 3 Getting Information Into and Out of a Database

Importing Information from a Delimited Text File To import an Excel worksheet into an existing table

  1. On the File menu, point to Get External Data, and then click Import.

  2. In the Files of type list, click Microsoft Excel.

  3. Navigate to the folder that contains the worksheet, click the file, and then click Import.

  4. Follow the instructions on the Import Excel Worksheet Wizard, and then click Finish to complete the process.

Importing Information from a Delimited Text File To import information from a text file into an existing table

  1. On the File menu, point to Get External Data, and then click Import.

  2. In the Files of type list, click Text Files.

  3. Navigate to the folder that contains the information, click ...

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