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

ID: Q168701

The information in this article applies to:

Microsoft Excel 97 for Windows

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:

   ARTICLE-ID: Q167669
   TITLE     : 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          : kbtool kbdta xladdins 
Version           : WINDOWS:97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbbug

Last Reviewed: November 1, 1998