PRB: Cannot Import Works for Macintosh Database File

ID: Q123968

2.60a MACINTOSH

 kbinterop  kbprb kbdocerr

The information in this article applies to:

Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS

Attempting to load a Works for Macintosh database file using the IMPORT.APP application results in the following error message when importing a Works version 2.0 for Macintosh database:

   Error Reading File

or the following error when importing a Works version 4.0 for Macintosh database:

   Not a Microsoft Works Database

CAUSE

IMPORT.APP is designed to import on Works version 3.0 for Macintosh database files.

RESOLUTION

Perform one of the following procedures to import a database file from Works version 2.0 or 4.0 for Macintosh.

To Import a Works Version 2.0 Database

1. Open the database file in Works version 2.0.

2. From the File menu, choose Save As.

3. Give the database a new name with a .TXT extension. Then choose the

   Export radio button. For example, use the name MYDB.TXT.

4. Choose the Save button.

5. In FoxPro, create a table structure that matches the Works database. The

   Works database will be imported into this table.

6. From the Database menu, choose Append From. In the File Type list,

   select Delimited with Tabs.

7. Choose the From button and select your exported Works version 2.0

   database. Choose OK to select the database. Then choose the Append
   button to import the information into the current table.

To Import a Works Version 4.0 Database

1. Open the database file in Works version 4.0.

2. From the File menu, choose Save As.

3. Give the database a new name. In the File Format list, select Works 3.0.

4. Choose the Save button.

5. In FoxPro, use IMPORT.APP to import the database as a Works version 3.0

   database file.

STATUS

This behavior is by design.

MORE INFORMATION

According to the FoxPro for Macintosh documentation (More Tips section of the FoxPro Welcome sheet and the Readme file), you can import a Works for Macintosh database file using an application called IMPORT.APP. However, it is not explicitly stated that IMPORT.APP can only read Works for Macintosh version 3.0 databases.

The IMPORT.APP is located in the FOXPRO:GOODIES:MISC folder and can be used to import 4th Dimension, FileMaker Pro, and Microsoft Works files.

To run IMPORT.APP, select Do from the Program menu. Then double-click IMPORT.APP in the Open list. Or issue the following commands in the Command window to run IMPORT.APP:

   SET DEFAULT TO "Macintosh HD:Microsoft FoxPro 2.6:Goodies:Misc"
   DO IMPORT.APP

Additional reference words: FoxMac 2.60a errmsg err msg docerr KBCategory: kbinterop kbprb kbdocerr KBSubcategory:

Keywords          : kberrmsg kbdocerr kbinterop kbprb
Version           : 2.60a
Platform          : MACINTOSH

Last Reviewed: May 21, 1998