PRB: Cannot Import Works for Macintosh Database File

 Last reviewed: May 16, 1996
Article ID: Q123968
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: kbtool kbinterop kberrmsg kbprb kbdocerr
KBSubcategory:

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 16, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.