SBFM: MS Visual C++ Run-Time Errors Importing Quickbooks Data

ID: Q170409

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Small Business Financial Manager 97 for Microsoft Excel 97

SYMPTOMS

When you try to import data from Intuit Quickbooks for Windows versions 3.1 and 4.0, or from Intuit Quickbooks Pro for Windows version 4.0, you may receive the following error messages.

Error Message 1

MS Visual C++ RunTime Library:
Run Time Error:
Program 'c:\program files\microsoft office\office\excel.exe.'
Abnormal program termination.

Then, the following message appears:

Excel caused an Invalid Page Fault in module DAO350.DLL @ 014F:06453410.

-or-

Error Message 2

Microsoft Visual C++ Run Time Library
Runtime Error!
Program 'c:\program files\microsoft office\office\excel.exe'
Abnormal program termination.

The following message appears

Excel caused an invalid page fault in module Kernel32.dll @ 0317:bff79888

and then the following message appears:

Excel caused an invalid page fault in module Dao350.dll @ 0137:06243410

CAUSE

Error Message 1

The first error message appears if the length of a company name is more than 32 characters.

Error Message 2

The second error message appears if a quotation mark ("), an apostrophe ('), an open bracket ([), or a close bracket (]) is used in any of the list element items: Chart Of Accounts, Items, or Class List. This problem may also occur if any of the list element items is more than 32 characters in length.

WORKAROUND

Error Message 1

To work around this problem, follow these steps:

Open the file in the version of Intuit Quickbooks in which the file was created.

On the File menu, click Company Info.

Shorten the company name to 32 or fewer characters.

Note that a space counts as a character.

Click OK.

On the File menu, click Close Company.

On the File menu, click Exit.

Run the Import Wizard in the Microsoft Small Business Financial Manager for Microsoft Excel 97.

Error Message 2

To work around this problem, follow these steps:

Open the file in the version of Intuit Quickbooks in which the file was created.

On the Lists menu, click Chart Of Accounts.

In the Name and Type columns, check for:
- A quotation mark ("), apostrophe ('), open square bracket ([), or close square bracket (]) character in the description for the Chart Of Accounts name or type.
- A description for the Chart Of Accounts name or type that exceeds 32 characters in length.

To change any of the items, click Edit, modify the name or type, and then click OK.

On the Lists menu, click Items.

In the Name, Description, Type, and Account columns, check for:
- A quotation mark ("), apostrophe ('), open square bracket ([), or close square bracket (]) character in the description of the item name, description, type, or account.
- A description for the item name, description, type, or account that exceeds 32 characters in length.

To change any of the items, click Edit, modify the item name, description, type, or account, and then click OK.

On the Lists menu, click Classes.

In the Name column, check for the following:
- A quotation mark ("), apostrophe ('), open square bracket ([), or close square bracket (]) character in the description of the Classes name.
- A description for the Classes name that exceeds 32 characters in length.

To change any of the items, click Edit, modify the Class name, and then click OK.

On the File menu, click Close Company.

On the File menu, click Exit.

Run the Import Wizard in the Microsoft Small Business Financial Manager for Microsoft Excel 97.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL97 ipf run-time

Keywords : kb3rdparty kberrmsg kbtool xlsbfm
Version : WINDOWS:97
Platform : WINDOWS
Issue type :