XL97: AccessLinks Add-in Fails with Large Number of Rows (168701)
The information in this article applies to:
- Microsoft Excel 97 for Windows
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
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.
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
and then double-click the selected text to go to the topic of your choice.
| Modification Type: | Major | Last Reviewed: | 10/22/2000 |
|---|
| Keywords: | kbbug KB168701 |
|---|
|