Microsoft KB Archive/209726

= HOW TO: Import Spreadsheets from MS Works for Windows in Access 2000 =

Article ID: 209726

Article Last Modified on 11/16/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.0 Standard Edition

-



This article was previously published under Q209726



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

IN THIS TASK

 * SUMMARY
 * To convert a Works for Windows spreadsheet to Access
 * To import a Works spreadsheet
 * REFERENCES



SUMMARY
This article explains how to transfer your spreadsheet files from Microsoft Works into a Microsoft Access database (.mdb).

back to the top

To convert a Works for Windows spreadsheet to Access
NOTE: If you have Microsoft Works 2.0, you can simply import the spreadsheet files directly into Access (see the "To import a Works spreadsheet" section later in this article) without having to complete the following steps. If you have Works 3.0 or later, first follow these steps:  Open the spreadsheet file in Works for Windows. On the File menu, click Save As.  Under Save File as Type, choose the appropriate converter:   Works for Windows 4.0 and later: click Lotus 1-2-3 Works for Windows 3.0x:         click Works 2.0  Click Save.

back to the top

To import a Works spreadsheet

 * 1) Start Access and open the database into which you want to import the Works spreadsheet.
 * 2) On the File menu, point to Get External Data, and then click Import.
 * 3) In the Import box, select the correct folder for the Look In field, and then click Lotus 1-2-3 in the Files of Type list. To import the spreadsheet, click the spreadsheet file that you want to import, and then click Import.
 * 4) This starts the Import Spreadsheet Wizard. Follow the instructions in the wizard to import your spreadsheet.

NOTE: If the first row of a Works spreadsheet contains column names, Access can use the column names as the field names for the new table. If the first row of the spreadsheet does not contain column names, Access uses default field names for the fields in the new table.

The fields in the new table have the same data types as your Works spreadsheet, with the following exceptions:


 * Fields formatted as TRUE or FALSE in Works are converted to Number fields in Access, with a 1 indicating True and a 0 indicating False.


 * Microsoft Works Formula fields are converted to Number fields with values.

back to the top

