| Data source |
Version or format supported |
| Microsoft Access database |
2.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/Access 2002, Access 2003 |
| Microsoft Access project |
9.0/2000, 10.0/Access 2002, Access 2003 |
| dBASE |
III, IV, and 5; and 7 (Linking requires updated ISAM drivers available from Microsoft Technical Support) |
| Microsoft Excel spreadsheets |
3.0, 4.0, 5.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/Excel 2002, and Excel 2003 |
| Paradox, Paradox for Microsoft Windows |
3.x, 4.x, and 5.0; and 8.0 (Linking requires updated ISAM drivers available from Microsoft Technical Support) |
| Microsoft Windows SharePoint Services |
2.0 |
| Lotus 1-2-3 spreadsheets (Linking is read-only) |
.wks, .wk1, .wk3, and .wk4 |
| Microsoft Exchange |
All versions |
| Delimited text files (delimited text file: A file containing data where individual field values are separated by a character, such as a comma or a tab.) |
All character sets |
| Fixed-width text files (fixed-width text file: A file containing data in which each field has a fixed width.) |
All character sets |
| HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) |
1.0 (if a list)
2.0, 3.x (if a table or list) |
| XML (Extensible Markup Language (XML): A condensed form of Standard Generalized Markup Language (SGML) that enables developers to create customized tags that offer flexibility in organizing and presenting information.) Documents |
All versions (import (import: To copy data from a text file, spreadsheet, or database table into an Access table. You can use the imported data to create a new table, or you can append (add) it to an existing table that has a matching data structure.) only) |
| SQL tables, Microsoft Visual FoxPro, and data from other programs and databases that support the ODBC (Open Database Connectivity (ODBC): A standard method of sharing data between databases and programs. ODBC drivers use the standard Structured Query Language (SQL) to gain access to external data.) protocol |
Visual FoxPro 2.x, 3.0, 5.0, and 6.x (import only)
For an up-to-date list of supported ODBC drivers (Open Database Connectivity (ODBC) driver: A program file used to connect to a particular database. Each database program, such as Access or dBASE, or database management system, such as SQL Server, requires a different driver.), see the Microsoft Knowledge Base.
|
