ACC2000: How to Import a Works Database into Microsoft Access
ID: Q197894
|
The information in this article applies to:
-
Microsoft Access 2000
-
Microsoft Works for Windows, versions 2.0, 2.0a, 3.0, 3.0a, 3.0b, 4.0, 4.0a, 4.5, 4.5a
Novice: Requires knowledge of the user interface on single-user computers.
SUMMARY
This article describes how to import a Works database file into a Microsoft
Access 2000 database. This is a two-step process. First you must save the
Works database file in a format compatible with Microsoft Access. Then you
can import the Works database into Microsoft Access.
MORE INFORMATIONSaving the Works Database File
Save the Works database file in a format compatible with Microsoft Access.
To do so, follow these steps:
- 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 that contains text to ensure that it is
General or Text formatting. If the format of a Text field is set
to a numeric format, such as Currency or Date, the field will be
blank when you open the database in Access.
- When you save in dBASE format (as you will do in step 8), 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,
these field names will be imported into Access with a default field
name, such as Field_1, Field_2, and so on.
- On the File menu, click Save As.
- Select a folder to which to save the database. To make the database easy
to locate, select the Access folder.
- Enter a new name, without an extension, in the File Name field.
NOTE: When you import a dBASE file that does not follow the MS-DOS 8.3
file name convention (that is, an 8-character name followed by a period
(.) and a 3-character extension), you may encounter problems when you
try to import the dBASE file into Microsoft Access. Therefore, be sure
to create a new file name that does not use more than 8 characters.
- In the Save File As Type list, select dBASE III or dBASE IV, and
click Save.
NOTE: If you receive the error message, "Some Field Text Was Truncated,"
return to step 2 and increase the field width.
- Quit Works.
NOTE: If Works does not add the .dbf extension, resave the file with this
extension.
Importing the Works Database into Access
To import the database into Access, follow these steps:
- Start Microsoft Access.
- In the Microsoft Access dialog box, under "Create a new database using,"
click to select Blank Access Database, and then click OK.
- Name the database, and then click Create.
- In the Database window, under Objects, click Tables, and then click New.
- In the New Table dialog box, select Import Table from the list, and then
click OK.
- In the Import dialog box, click the arrow in the Look In box, and select
the folder that contains the dBASE file that you created in Microsoft
Works. Click the arrow in the Files Of Type box, and select either dBASE
III or dBASE IV, depending on the format you chose in step 8 of the
"Saving the Works Database File" section earlier in this article.
- Click the database that you want to use, and then click Import.
You should receive a message that the file has been successfully imported.
Click OK. Then close the Import dialog box.
The Works file has been imported into Access. If you want to view the
imported data, select the new table in the Database Window, and click Open.
If you want to discard the Works file used to transfer your data into
Microsoft Access, delete the file.
Additional query words:
w_works bring convert transfer inf
Keywords : kbinterop kbdta
Version : WINDOWS:2.0,2.0a,2000,3.0,3.0a,3.0b,4.0,4.0a,4.5,4.5a
Platform : WINDOWS
Issue type : kbinfo
|