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

ID: Q136139

The information in this article applies to:

Microsoft Access 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 : kb3rdparty IsmGnrl
Version : 7.0
Platform : WINDOWS
Issue type : kbinfo