|
 |
 |
 |
|
Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms
of Use |
Trademarks
Article ID: 283294 - Last Review: October 21, 2005 - Revision: 8.0 List of supported data sources for importing, exporting, and linking in an Access 2002 databaseThis article was previously published under Q283294 This article applies only to a Microsoft Access database (.mdb).
Novice: Requires knowledge of the user interface on single-user computers.
For a Microsoft Access 2000 version of this article, see 180105Â
(http://kbalertz.com/Feedback.aspx?kbNumber=180105/
)
.
Microsoft Access can import or link data from other Microsoft Access databases (version 2.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/2002), as well as data from other programs and file formats, such as Microsoft Excel, dBASE, Paradox, or XML (import only). You can also import or link (read-only) HTML tables and lists that reside on your local computer, network server, or Internet server.
Microsoft Access can also export tables to these file formats, as well as to Rich Text format and dynamic HTML file formats.
For more information about importing, exporting and linking to data sources in an Access project (*.adp), click the following article number to view the article in the Microsoft Knowledge Base:
291133Â
(http://kbalertz.com/Feedback.aspx?kbNumber=291133/
)
Supported data sources for importing, for exporting, and for linking in an Access 2002 database project
The following table lists the formats supported by Access 2002. Listed also are some formats that are not supported, and those that have limited support. Note The numbers in parentheses refer to the notes that appear after this table. Collapse this tableExpand this table | File type | Extension | Import | Link | Export |
|---|
| Microsoft Access 1.x | .mdb | No | No | No | | Microsoft Access 2.0 | .mdb | Yes | Yes | Yes | | Microsoft Access 7.0 | .mdb | Yes | Yes | Yes | | Microsoft Access 97 | .mdb | Yes | Yes | Yes | | Microsoft Access 2000 | .mdb | Yes | Yes | Yes | | Microsoft Access 2002 | .mdb | Yes | Yes | Yes | | Text (Delimited) | .txt | Yes | Yes (4) | Yes | | Text (Fixed Width) | .txt | Yes | Yes (4) | Yes | | Microsoft Excel 3.0 | .xls | Yes | Yes | Yes | | Microsoft Excel 4.0 Sheets | .xls | Yes | Yes | Yes | | Microsoft Excel 4.0 Workbooks | .xlw | No | No | No | | Microsoft Excel 5.0-7.0 Workbooks | .xls | Yes | Yes | Yes | | Microsoft Excel 97 Workbooks | .xls | Yes | Yes | Yes | | Microsoft Excel 2000 Workbooks | .xls | Yes | Yes (5) | Yes | | Microsoft Excel 2002 Workbooks | .xls | Yes | Yes (5) | Yes | | Lotus 1-2-3 | .wk1 | Yes | Yes (1) | Yes | | Lotus 1-2-3 3.0 | .wk3 | Yes | Yes (1) | Yes | | dBASE III | .dbf | Yes | Yes (2) | Yes | | dBASE IV | .dbf | Yes | Yes (2) | Yes | | dBASE 5 | .dbf | Yes | Yes (2) | Yes | | Paradox 3.0 | .db | Yes | Yes (2) | Yes | | Paradox 4.0 | .db | Yes | Yes (2) | Yes | | Paradox 5.0 | .db | Yes | Yes (2) | Yes | | Exchange/Outlook | .pst | Yes | Yes | No | | HTML Documents | .html, .htm | Yes | Yes | Yes | | Microsoft Internet Database Connector | .idc/.htx | No | No | Yes | | Microsoft Active Server Pages | .asp | No | No | Yes | | Rich Text Format | .rtf | No | No | Yes | | ODBC Datasources (3) | N/A | Yes | Yes | Yes | | XML Files | .xml | Yes | No | Yes |
- Lotus 1-2-3 files can be linked, but they will be read-only.
- Linked dBASE and Paradox tables are read-only; however, you can resolve this issue by installing one of the following:
- The latest Microsoft Jet 4.0 service pack
- The Borland Database Engine
For more information, see the articles listed in the "References" section later in this article. - To be able to work with an ODBC data source you must have the correct and up-to-date ODBC drivers for the data source that you are using. For example, Access 2002 does not provide an ISAM driver for Microsoft FoxPro files (.dbc). However, you can use the ODBC drivers that are included with Access to connect to FoxPro files. See the "References" section later in this article.
- When linking text files, the existing data cannot be edited. Records can be added to the linked text file, but once the record has been committed, existing records cannot be updated.
- In the Microsoft Office 2002 update dated 10/18/05 (KB904018), by design you cannot update a linked Microsoft Excel Spreadsheet.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
904953Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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
The list above differs slightly from the information found in the Access 2002 Help file. The information in the Help file is not accurate, and the list above provides the correct information. The following Help topics contain inaccurate information:
- Data sources Microsoft Access can import or link
- Data formats Microsoft access can export
- Import or link Paradox tables
- Import or link dBase files
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.
For more information about importing, exporting, and linking to Paradox tables, click the following article number to view the article in the Microsoft Knowledge Base:
230126Â
(http://kbalertz.com/Feedback.aspx?kbNumber=230126/
)
How to use Paradox data with Access and Jet
For more information about importing, exporting, and linking to dBase files, click the following article number to view the article in the Microsoft Knowledge Base:
230125Â
(http://kbalertz.com/Feedback.aspx?kbNumber=230125/
)
How to use dBASE data with Access and Jet
For more information about importing, exporting, and linking to FoxPro files, click the following article number to view the article in the Microsoft Knowledge Base:
286224Â
(http://kbalertz.com/Feedback.aspx?kbNumber=286224/
)
No option to import, link, or export to the FoxPro file type
APPLIES TO- Microsoft Access 2002 Standard Edition
| kb3rdparty kbhowto KB283294 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
|
 |
|
 |
|
|
|
| |