Microsoft KB Archive/93698

= ACC: How to Import Spreadsheets from Microsoft Works for Windows =

Article ID: 93698

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q93698



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



SUMMARY
Microsoft Access can import Microsoft Works version 2.0 spreadsheet (.wks) files directly. This article explains how to transfer your spreadsheet files from Microsoft Works into a Microsoft Access database (.mdb).

NOTE: If you use Microsoft Works 3.0 or later, you need to save your spreadsheets in Microsoft Works 2.0 format. After the spreadsheet is saved in version 2.0 format, you can import it into Microsoft Access using the steps below.



MORE INFORMATION
To import a Works spreadsheet, follow these steps:

In Microsoft Access 7.0 and 97

 * 1) Start Microsoft Access and open the database into which you want to import the Microsoft Works spreadsheet.
 * 2) On the File menu, click 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 (*.wk*) in the Files Of Type list. To Import the spreadsheet, click the spreadsheet file 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 into Microsoft Access.

In Microsoft Access 1.x and 2.0

 * 1) Start Microsoft Access and open the database into which you want to import the Microsoft Works spreadsheet.
 * 2) On the File menu, click Import.
 * 3) In the Data Source box, select &quot;Lotus (WKS),&quot; and then click OK.
 * 4) In the File Name box, select the spreadsheet file you want to import, and then click Import. If the first row of the spreadsheet contains column names, select the First Row Contains Field Names check box. Click OK. The file is imported into a table with the same name as the spreadsheet file.
 * 5) After the database is imported, click Close.

NOTE: If the first row of a Works spreadsheet contains column names, Microsoft 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, Microsoft 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:


 * Microsoft Works fields formatted as TRUE or FALSE are converted to Number fields.
 * A Microsoft Works FALSE value is converted to 0 and a TRUE value is converted to 1.
 * Microsoft Works Formula fields are converted to Number fields with values.

