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

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

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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