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
On the File menu, point to Get External Data, and then click Import.
In the Files of type list, click Microsoft Excel.
Navigate to the folder that contains the worksheet, click the file, and then click Import.
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
On the File menu, point to Get External Data, and then click Import.
In the Files of type list, click Text Files.
Navigate to the folder that contains the information, click ...
Get Microsoft® Office Access 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
