ACC2000: Error Message When You Try to Import a Lotus .WK1 File (260308)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q260308
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you try to import a Lotus 1-2-3 .wk1 file, you may receive the following Import Spreadsheet Wizard error:
The Microsoft Jet database engine could not find the object <filename>:. Make sure the object exists and that you spell its name and the path name correctly.
When you click OK, the table is not imported.

CAUSE

You have installed Microsoft Jet 4.0 Service Pack 4.

RESOLUTION

To work around this behavior, use the Lotus 1-2-3/DOS ISAM to import a .wk1 file. To do so, follow these steps:
  1. On the File menu, point to Get External Data, and then click Import.
  2. In the Import dialog box, browse to the folder where your .wk1 file is located.
  3. In the Files of type box, click the arrow, and then click Lotus 1-2-3/DOS (*.wj*) in the list that appears. Your .wk1 file appears in the Import dialog box.
  4. Click your .wk1 file, and then click Import. Note that the Import Objects dialog box appears and that the name of your .wk1 file appears two times: the first time without a colon after the file name, and the second time with a colon after the file name.
  5. Click the first occurrence of the file name, and then click OK. Note that the file is imported.
NOTE: If you were to click the second occurrence of the file name (the one that ends in a colon), you would see the error described in the "Symptoms" section of this article.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Jet 4.0 Service Pack 4.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Install a new copy of Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows NT.
  2. Install Microsoft Access 2000 and Microsoft Jet 4.0 Service Pack 4.
  3. Open the sample database Northwind.mdb.
  4. Right-click the Customers table, and then click Export.
  5. In the Export dialog box, browse to the root folder of drive C.
  6. In the Save as type list, click Lotus 1-2-3 WK1 (*.wk1), and then click Save. This creates a Lotus 1-2-3 test file.
  7. On the File menu, point to Get External Data, and then click Import.
  8. In the Files of type box, click the arrow, and then click Lotus 1-2-3 (*.wk*) in the list that appears. Note that the Customer.wk1 file appears in the Import dialog box.
  9. Click Import.
Note that you receive the error mentioned in the "Symptoms" section of this article.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbbug kberrmsg KB260308
©2004 Microsoft Corporation. All rights reserved.