ACC95: Supported File Types for Import, Export, and Link

Last reviewed: January 30, 1998
Article ID: Q136139

The information in this article applies to:

Microsoft Access version 7.0

SUMMARY

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

This article lists the supported file types for importing, exporting, and linking data using the various ISAM drivers installed by Microsoft Access for Windows 95 version 7.0.

For information about supported file types in Microsoft Access for Windows version 8.0, search the Help Index for "supported file types," or ask the Microsoft Access 97 Office Assistant.

MORE INFORMATION

 File Type                   Extension            Import   Link   Export
 -----------------------------------------------------------------------

 Microsoft Access 1.x          .mdb                 Yes     Yes     No

 Microsoft Access 2.0          .mdb                 Yes     Yes     No

 Microsoft Access 7.0          .mdb                 Yes     Yes     Yes

 Text (Delimited)              .txt                 Yes     Yes     Yes

 Text (Fixed Width)            .txt                 Yes     Yes     Yes

 Microsoft Excel 3.0           .xls                 Yes     Yes     Yes

 Microsoft Excel 4.0           .xls                 Yes     Yes     Yes
                               .xlw                 No      No      No

 Microsoft Excel 5.0-7.0       .xls                 Yes     Yes     Yes

 Lotus 1-2-3                   .wk1                 Yes     No      Yes

 Lotus 1-2-3 3.0               .wk3                 Yes     No      Yes

 Lotus 1-2-3 4.0               .wk4                 Yes     No      No

 dBASE III                     .dbf                 Yes     Yes     Yes

 dBASE IV                      .dbf                 Yes     Yes     Yes

 dBASE for Windows 5.0         .dbf                 Yes     Yes     Yes

 Paradox 3.0                   .db                  Yes     Yes     Yes

 Paradox 4.0                   .db                  Yes     Yes     Yes

 Paradox 5.0                   .db                  Yes     Yes     Yes

 Microsoft FoxPro 2.0          .dbf                 Yes     Yes     Yes
                               .fpt                 Yes     Yes     Yes
                               .idx                 Yes     Yes     No
                               .cdx                 Yes     Yes     Yes

 Microsoft FoxPro 2.5          .dbf                 Yes     Yes     Yes
                               .fpt                 Yes     Yes     Yes
                               .idx                 Yes     Yes     No
                               .cdx                 Yes     Yes     Yes

 Microsoft FoxPro 2.6          .dbf                 Yes     Yes     Yes
                               .fpt                 Yes     Yes     Yes
                               .idx                 Yes     Yes     No
                               .cdx                 Yes     Yes     Yes

 Microsoft Visual FoxPro 3.0   .dbc                 Yes     No      No

NOTE: In Microsoft Access for Windows 95 version 7.0, you cannot link to a Visual FoxPro 3.0 database using the Microsoft Access 7.0 User Interface (UI). To establish a link to a Visual FoxPro 3.0 database in Microsoft Access 7.0, you need to use Visual Basic for Applications code.

REFERENCES

For more information about importing, exporting, or linking data, search for "Supported File Types" using the Answer Wizard from the Microsoft Access for Windows 95 Help menu.

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.

Keywords          : IsmGnrl kb3rdparty
Version           : 7.0
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbinfo

================================================================================

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