Microsoft KB Archive/168701: Difference between revisions
(importing KB archive) |
m (Text replacement - "<" to "<") |
||
Line 47: | Line 47: | ||
<div class="errormessage"> | <div class="errormessage"> | ||
The Microsoft Jet database engine could not find the object ' | The Microsoft Jet database engine could not find the object '<selection>'. Make sure the object exists and that you spell its name and the path name correctly. | ||
</div> | </div> | ||
where | where <selection> contains the name of the active worksheet and the selected range of cells. | ||
</div> | </div> |
Revision as of 17:00, 20 July 2020
Article ID: 168701
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q168701
SYMPTOMS
In Microsoft Excel 97, if you click Convert To MS Access on the Data menu to convert a Microsoft Excel list to a Microsoft Access 97 database, you may receive the following error message
where <selection> contains the name of the active worksheet and the selected range of cells.
CAUSE
This behavior is caused by a limitation in the Microsoft AccessLinks add- in. If you want to convert a Microsoft Excel list to a Microsoft Access database, you are limited to converting 16383 rows.
WORKAROUND
To work around this problem, please see the following article in the Microsoft Knowledge Base:
167669 XL97: Data Truncated to 16,384 Rows When Imported Into MS Access
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
MORE INFORMATION
The Microsoft AccessLinks add-in creates Microsoft Access forms and reports to use with Microsoft Excel lists, and imports Microsoft Excel lists into Microsoft Access. When the Microsoft AccessLinks add-in is loaded, it adds three menu commands to the Data menu: MS Access Form, MS Access Report, and Convert To MS Access.
REFERENCES
For more information about the AccessLinks add-in, click the Index tab in Microsoft Excel 97 Help, type the following text
AccessLinks add-in
and then double-click the selected text to go to the topic of your choice.
Additional query words: 97 XL97
Keywords: kbbug KB168701