Microsoft KB Archive/123968

{| = PRB: Cannot Import Works for Macintosh Database File =
 * width="100%"|

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
 * }