Microsoft KB Archive/168701

= XL97: AccessLinks Add-in Fails with Large Number of Rows =

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

The Microsoft Jet database engine could not find the object ' '. Make sure the object exists and that you spell its name and the path name correctly.

where 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.

