Article ID: 830797
Article Last Modified on 6/12/2006
APPLIES TO
- Microsoft Access 2000 Standard Edition
- Microsoft Access 2002 Standard Edition
- Microsoft Office Access 2003
This article applies only to a Microsoft Access project (.adp).
Moderate: Requires basic macro, coding, and interoperability skills.
Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows registry
SUMMARY
In a Microsoft Office Access database project (.adp), if you use Microsoft SQL Server as the database engine, you can link data from other programs and from other file formats, such as Microsoft Excel, dBase, Paradox, or XML. You can also import or link Access databases (.mdb), HTML tables, and lists that reside on the local computer, the network server, or the Internet server. However, you cannot modify the structure of the linked tables from Access.
MORE INFORMATION
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
The following table lists the formats that are supported by Access. The following table also lists formats that are not supported and formats that have limited support.
Note The numbers in parentheses indicate the restrictions that apply. For more information, see the list of restrictions after the table.
| File Type | Extension | Import | Link | Export |
|---|---|---|---|---|
| Microsoft Access 2.0 | .mdb | Yes (1) | Yes (1) | Yes (1)(2) |
| Microsoft Access 7.0 | .mdb | Yes | Yes | Yes (2) |
| Microsoft Access 97 | .mdb | Yes | Yes | Yes (2) |
| Microsoft Access 2000 | .mdb | Yes | Yes | Yes (2) |
| Microsoft Access 2002 | .mdb | Yes | Yes | Yes (2) |
| Microsoft Office Access 2003 | .mdb | Yes | Yes | Yes (2) |
| Text (Delimited) | .txt | Yes | Yes (3) | Yes |
| Text (Fixed Width) | .txt | Yes | Yes (3) | Yes |
| Microsoft Excel 3.0 | .xls | Yes | Yes | Yes |
| Microsoft Excel 4.0 | .xls | Yes | Yes | Yes |
| Microsoft Excel 5.0-7.0 | .xls | Yes | Yes | Yes |
| Microsoft Excel 97-2000 | .xls | Yes | Yes | Yes |
| Microsoft Excel 2002 | .xls | Yes | Yes (7) | Yes |
| Microsoft Office Excel 2003 | .xls | Yes | Yes (7) | Yes |
| Microsoft Windows SharePoint Services | N/A | Yes (8) | No | Yes (8) |
| Microsoft Word Merge | .txt | Yes (8) | No | Yes (8) |
| Lotus 1-2-3 | .wk1 | Yes | No | Yes |
| Lotus 1-2-3 | .wj2 | Yes | No | Yes |
| Lotus 1-2-3 3.0 | .wk3 | Yes | No | Yes |
| dBase III, IV, 5 | .dbf | Yes | Yes | Yes |
| Paradox 3, 4, 5 | .db | Yes | Yes | Yes |
| Paradox 7-8 | .db | Yes (4) | Yes (4) | Yes (4) |
| Exchange/Outlook | .pst | Yes | No | No |
| HTML Documents (Static) | .html, .htm | Yes | Yes (3) | Yes |
| Microsoft IIS 1-2 (Dynamic HTML Format) | *.htx/ *.idc | No | No | Yes |
| Microsoft Active Server Pages | .asp | No | Yes (5) | Yes |
| Rich Text Format | .rtf | No | No | Yes |
| ODBC Data Sources | N/A | Yes | Yes (6) | Yes |
| XML Files | .xml | Yes | No | Yes |
| XML Files | .xsd | Yes | No | No |
You must be aware of the following restrictions:
- You must install the Microsoft Access 2.0 Converter so that you can use Access 2.0 files in Access 2003.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:830271 BUG: You receive an error message when you open or convert an Access 2.0 database file in Access 2003
- The Access database must already exist. Only tables can be exported to an Access 97 and earlier file.
- The Link Table Wizard uses the first row of data as the column headings. For text files and for HTML files, examine the first row and then insert the appropriate column headings if the column headings are required.
If you link to large text files (.txt or .html), an Open Database Connectivity (ODBC) Timeout error may occur. To permit Access to successfully transfer text data or to successfully link text data to Microsoft SQL Server, you must increase the QueryTimeout value in the registry, or you must disable the ODBC Timeout by setting the value to 0 (zero).
The following registry key controls the QueryTimeout value:HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\ODBC\QueryTimeout - The functionality, marked by (4) in the previous table, requires Borland Database Engine (BDE) for Paradox 7-8 format files.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:230126 How to use Paradox data with Access and Jet
- An .asp page can be used as a linked table if the .asp page contains valid
elements.- When you try to link to Microsoft SQL Server 7.0 or to Microsoft SQL Server 2000 by using a system data source name (DSN), you may receive the following error message: You can prevent this error when you try to connect to SQL Server. To prevent this error, click Microsoft SQL Server in the Data Connection Wizard. Do not click ODBC DSN in the Data Connection Wizard.
- In the Microsoft Office 2002 update that is dated October 18, 2005 (KB904018), and in Microsoft Office 2003 Service Pack 2 (SP2), you cannot update a linked Microsoft Excel spreadsheet. This behavior is by design. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
904953 You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2003 or in Access 2002
- Only Access 2003 supports importing or exporting Microsoft Windows SharePoint Services lists and Microsoft Word Merge. This support was not available in earlier versions of Access.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
REFERENCES
For more information about how to export database objects, click Microsoft Office Access Help on the Help menu, type Export data or database objects in the Search for box in the Assistance pane, and then click Start searching to view the topic.
For more information about linking, click Microsoft Office Access Help on the Help menu, type Link tables in an Access project by using the Link Table Wizard (ADP) in the Search for box in the Assistance pane, and then click Start searching to view the topic.
For more information about how to import from a Windows SharePoint Services list in Access 2003, click Microsoft Office Access Help on the Help menu, type Import from a Microsoft Windows SharePoint Services list in the Search for box in the Assistance pane, and then click Start searching to view the topic. For more information about the supported data sources for importing, for exporting, and for linking in an Access database, click the following article number to view the article in the Microsoft Knowledge Base:826507 Supported data sources for importing, for exporting, and for linking in an Access database
Additional query words: acc2000 Accesss 2000 acc2002 Access 2003 acc2003 Access 2003
Keywords: kbinfo kbregistry kbexport kbimport kbformat KB830797
