ACC97: Error Exporting Access Table or Query to Existing Excel File with Chart Sheet (225353)

SYMPTOMS

You may experience the following problem when you export a table or query from a Microsoft Access database to an existing Microsoft Excel workbook, containing a chart sheet.

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.

When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:

MSACCESS caused an invalid page fault in MSEXCL35.DLL at 015f:022bdf9c.

NOTE: The actual memory address may vary.

If you are using Microsoft Windows NT, you receive the following error message:

An application error has occurred and an application error log is being generated.

msaccess.exe
Exception: access violation (0xc0000005), Address 0x08f1df9c

NOTE: The actual memory address may vary.

MORE INFORMATION

This problem does not occur if the chart is embedded on a worksheet.

For additional information about the Microsoft Jet 3.51 Service Pack 2, please see the following article in the Microsoft Knowledge Base:

172733 Updated Version of Microsoft Jet 3.5 Available for Download

Steps to Reproduce Behavior

Create an Excel file that contains a chart on a chart sheet.
Save the file and close Excel.
Open the sample database Northwind.mdb.
Select the Shippers table.
On the File menu, click Save As/Export.
Choose To an External File or Database, and then click OK.
In the Save as type list, select Microsoft Excel 97.
Select the file that you created in step 1, and then click Export.

Note that you receive one of the errors mentioned in the "Symptoms" section.