Help and Support
 

powered byLive Search

ACC: How to Import FoxBase for Macintosh Files

Retired KB ArticleThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Article ID:109331
Last Review:January 18, 2007
Revision:2.1
This article was previously published under Q109331
Novice: Requires knowledge of the user interface on single-user computers.

SUMMARY

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.

APPLIES TO
Microsoft Access 1.0 Standard Edition
Microsoft Access 1.1 Standard Edition
Microsoft Access 2.0 Standard Edition
Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

Back to the top

Keywords: 
kb3rdparty kbhowto KB109331

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.