This article describes how to import a Works Database file into a Microsoft
Access 95 (version 7.0) or Microsoft Access 97 database.
Save the Works Database File
Save the Works Database file in a format compatible with Microsoft Access
by doing the following:
- Open the database in Works.
- Make sure the field widths in Form view are large enough to
display all the information in the field.
- Check the format of each field containing text, to ensure it is
General or Text formatting. If the format of a text
field is set to a numeric format, such as Currency or
Date, that field will be blank when opened in Access.
- When you save in dBASE format, field names will be truncated at 10
characters, so ensure the first 10 characters of each field name
are unique. For example, two fields named "Address 1" and "Address 2"
would be OK, but "Address Line 1" and "Address Line 2" would not be.
NOTE: If the first 10 characters in two or more fields are the
same, the additional field name(s) will be imported into Access
with a default field name, such as, Field_1, Field_2.
- On the File menu, click Save As.
- Select a folder to save the database to; to make it easy to
locate, select the Access folder.
- Type a new name, without an extension, in the File Name
NOTE: The name cannot be over eight characters in length.
- From the Save File As Type list, select dBASE III or
dBASE IV and click OK.
NOTE: If the error message, Some Field Text Was Truncated, is
displayed, return to step 2 and increase the field width.
- Exit Works.
: If Works does not add the .dbf extension, resave the file
with this extension.
Import the Works Database into Microsoft Access
To import the database created above into Microsoft Access, follow these
- Start Microsoft Access.
- In the Create A New Database Using dialog box, select Blank
Database and click OK.
- Name the database and click Create.
- On the Tables tab, click New.
- In the New Table dialog box, select Import Table, from
the list and then click OK.
- Change the Look In box to the folder that contains the Works
database, and change the Files Of Type box to either dBASE
III or dBASE IV, depending on the format you chose in the
- Click the database you want to use and then click
You should receive a message that the file has been successfully imported.
. Then close the Import
The Works file has been imported into Access. If you want to view the
imported data, click the new table in the Tables
list and click Open
. If you want to discard the Works file used to transfer your data into Microsoft Access, delete the file.
For information about importing Works Spreadsheets into Microsoft Access,
please see the following article in the Microsoft Knowledge Base:
INF: Importing Spreadsheets from Microsoft Works for Windows
Article ID: 154167 - Last Review: November 15, 2004 - Revision: 4.0
- Microsoft Works 2.0 Standard Edition
- Microsoft Works 2.0a
- Microsoft Works 3.0 Standard Edition
- Microsoft Works 3.0a
- Microsoft Works 3.0b
- Microsoft Works 4.5 Standard Edition
- Microsoft Works 4.5a
- Microsoft Works 4.0 Standard Edition
- Microsoft Works 4.0a
|kbinfo kbinterop KB154167|Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.