HOW TO: Import Spreadsheets from MS Works for Windows in Access 2000 (209726)

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:

1. Open the spreadsheet file in Works for Windows.
2. On the File menu, click Save As.
3. 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
   					

4. 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