ACC: How to Import FoxBase for Macintosh Files

 Last reviewed: April 2, 1997
Article ID: Q109331
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

FoxBase for Macintosh files can be imported or linked (attached) in Microsoft Access by specifying a dBASE III Data Source file type.

MORE INFORMATION

Although you can import or link FoxBase for Macintosh files in Microsoft Access by specifying a dBASE III Data Source file type, make sure to note the following restrictions:

  • You cannot import FoxBase for Macintosh files that contain fields with a PICT data type. The PICT data type is similar to the Microsoft Access OLE data type. If you import a file that contains a field with a PICT data type, you will receive the following error message: 

          External table isn't in the expected format.
  • You can import FoxBase for Macintosh files that contain Memo fields only if the associated .DBT file is present. The .DBT file must be located in the same directory as the FoxBase (.DBF) file. The .DBT file will be incorporated into the Microsoft Access table and is not needed by Microsoft Access after the import process is complete.

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Additional query words: foxbase import macintosh
Keywords : IsmXbase kb3rdparty
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbhowto

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: April 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.