Microsoft KB Archive/915515

= You receive an error message after you try to import accounts from an Excel worksheet into Accounting Professional 2007, into Accounting Express 2007, or into Small Business Accounting 2006 =

Article ID: 915515

Article Last Modified on 2/13/2007

-

APPLIES TO


 * Microsoft Office Accounting Professional 2007
 * Microsoft Office Accounting Express 2007
 * Microsoft Office Small Business Accounting 2006

-





SYMPTOMS
Consider the following scenario. You are using one of the following products:
 * Microsoft Office Accounting Professional 2007
 * Microsoft Office Accounting Express 2007
 * Microsoft Office Small Business Accounting 2006

After you try to import accounts into one of these products from a Microsoft Office Excel worksheet, you receive one of the following error messages:

Error message 1

Current liability cannot Import. The account type is not an account type.

Error message 2

Long term liability cannot Import. The account type is not an account type.

Error message 3

Fixed Asset cannot Import. The account type is not an account type.



CAUSE
This problem occurs because an incorrect account type is specified in the Excel worksheet that you want to import.



RESOLUTION
To resolve this problem, follow these steps:  Open the ImportData.xls template file, and then verify the account types that you can use in the Excel worksheet.

Note The first column in this file contains the account types that can be specified in the Excel worksheet. By default, the ImportData.xls file is located in the following directories:  In Accounting Professional 2007 and in Accounting Express 2007, the following directory is the default directory for the ImportData.xls file:

C:\Program Files\Microsoft Small Business\Small Business Accounting 2007\Templates\Excel

 In Small Business Accounting 2006, the following directory is the default directory for the ImportData.xls file:

C:\Program Files\Microsoft Small Business\Small Business Accounting\Templates\Excel

  Modify the Excel worksheet. To do this, follow these steps:  Open the Excel worksheet.</li> If an account type in the Excel worksheet is not listed in the ImportData.xls template file, change the account type.

For example, if an account type is listed as Current Liability, change it to Current Liabilities.</li> On the File menu, click Save, and then click Close.</li></ol> </li> Import the Excel worksheet.</li></ol>

Keywords: kberrmsg kbtshoot kbprb kbmbsmigrate KB915515

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.