Data sources Microsoft Access can import or link
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Note You can link a table only in a Microsoft Access database, not a Microsoft Access project.
| Data source | Version or format supported |
|---|---|
| Microsoft Access database | 2.0, 7.0/95, 8.0/97, 9.0/2000 |
| Microsoft Access project | 9.0/2000 |
| dBASE | III, III+, IV, and 5
7 (Linking (read/write) requires Borland Database Engine 4.x or later ) |
| Paradox, Paradox for Windows | 3.x, 4.x, and 5.0
8.0 (Linking (read/write) requires Borland Database Engine 4.x or later ) |
| Microsoft Excel spreadsheets | 3.0, 4.0, 5.0, 7.0/95, 8.0/97, and 9.0/2000 |
| Lotus 1-2-3 spreadsheets (Linking is read-only) | .wks, .wk1, .wk3, and .wk4 |
| Microsoft Exchange | All versions |
| Delimited text files | All character sets |
| Fixed-width text files | All character sets |
| HTML | 1.0 (if a list) 2.0, 3.x (if a table or list) |
| SQL tables, Microsoft Visual FoxPro, and data from other programs and databases that support the ODBC protocol | Visual FoxPro 2.x, 3.0, 5.0, and 6.x (import only) |