ACC: How to Import a Works Database into Microsoft Access

MORE INFORMATION

Save the Works Database File

1. Open the database in Works.
2. Make sure the field widths in Form view are large enough to display all the information in the field.
3. 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.
4. 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.
5. On the File menu, click Save As.
6. Select a folder to save the database to; to make it easy to locate, select the Access folder.
7. Enter a new name, without an extension, in the File Name field.
8. 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.
9. Quit Works.

Import the Works Database into Access

1. Start Access.
2. In the Create A New Database Using dialog box, select Blank Database and click OK.
3. Name the database and click Create.
4. On the Tables tab, click New.
5. In the New Table dialog box, select Import Table, from the list and then click OK.
6. 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 steps above.
7. Click the database you want to use and then click Import.