Microsoft Jet provides the capability to access non-native, or external, data such as HTML tables and lists, Microsoft Exchange and Microsoft Outlook folders, and Microsoft FoxPro, Lotus 1-2-3, dBASE, and Paradox databases. The process of retrieving and storing non-native data is handled by the following external ISAM driver components (also known as installable ISAM drivers).
| Component | Description |
| MSExcl35.dll | Provides access to Microsoft Excel worksheets and workbooks created by versions 3.0, 4.0, 5.0, 7.0, and 8.0. Microsoft Jet 2.5 introduced access to Microsoft Excel data but it was not until Microsoft Access 95 and Visual Basic 4.0 that this functionality became available to Microsoft Jet users. |
| MSRd2x35.dll | Provides access to Microsoft Jet 1.x and 2.0 databases. The storage engine and format were completely revised with Microsoft Jet 3.0. Given the large number of structural changes, Microsoft Jet 3.5 treats version 2.0 databases as external ISAM databases. |
| MSLtus35.dll | Provides access to Lotus 1-2-3 worksheets created by versions 1.x, 2.x, 3.x, and 4.x. |
| MSPdox35.dlL | Provides access to Paradox tables from versions 3.5, 4.0, 4.5, and 5.0. |
| MSXbse35.dll | Provides access to XBase files including dBASE versions III, IV, and V, and FoxPro versions 2.0, 2.5, 2.6, and 3.0. |
| MSText35.dll | Provides the services required for accessing text files. With Microsoft Jet, you can either link (attach) or directly open text files, which can be stored in either fixed-width or delimited format. The procedures for retrieving the data in text files are similar to those used to access data in other external data sources. Generally, the ability to access text files is provided so you can import existing text files into your Microsoft Jet database, or export Microsoft Jet or other linked database tables to text files. |
See Also For more information about accessing external data, see Chapter 8, “Accessing External Data.”