Microsoft KB Archive/136139

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

Article ID: 136139

Article Last Modified on 6/24/2002

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q136139



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



SUMMARY
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.

