Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 199140 - Last Review: July 14, 2004 - Revision: 1.1
ACC2000: #Error in Linked Spreadsheet After Closing File in Excel
This article was previously published under Q199140
Novice: Requires knowledge of the user interface on single-user computers.
When you are viewing a linked Microsoft Excel table, you see #Error in all of the data fields.
If you try to edit the table at this point, you receive the following error
message:
The connection for viewing your linked Microsoft Excel worksheet was lost.
The spreadsheet was closed in Excel, and Microsoft Access lost its established link to the spreadsheet.
To re-establish the link to the Excel spreadsheet, close and reopen the
linked table in Access.
Steps to Reproduce Behavior
-
In Access, open the sample database Northwind.mdb.
-
In the Database window, select the Order Details table.
-
On the File menu, click Export.
-
In the Export Table 'Order Details' To box, click Microsoft Excel 5-7 or Microsoft Excel 97-2000, and in the Save As Type list, click Save.
-
On the File menu, point to Get External Data, and then click Link Tables.
-
In the Link box, click Microsoft Excel in the Files Of Type list, and then select the Order Details spreadsheet that you created. Click Link.
- In the Link Spreadsheet Wizard, click Next on the screen marked Your spreadsheet file contains more than one worksheet or range.
-
On the screen marked Microsoft Access can use your column headings as field names for your table, click First Row Contains Column Headings, and then click Next.
-
On the screen marked That's all the information the wizard needs to link to your data, accept the default for the Linked Table Name. Click Finish. Click OK on the informational message box.
-
Open Microsoft Excel, and then open the Order Details spreadsheet.
-
Open the linked table, Order_Details, in Microsoft Access.
-
Close the spreadsheet in Microsoft Excel.
-
Switch back to the Order_Details table in Microsoft Access.
Note that all of the data fields in the linked table, Order Details, contain #Error. If you try to edit the table, you will receive one of the error messages mentioned in the "Symptoms" section.
For more information about linking to a Microsoft Excel spreadsheet, click
Microsoft Access Help on the
Help menu, type
spreadsheets, importing or linking in the Office Assistant or
the Answer Wizard, and then click
Search to view the topics
returned.
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kberrmsg kbinterop kbprb KB199140 |
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