Microsoft KB Archive/906096

= How to import master records into Accounting Professional, into Accounting Express, or into Small Business Accounting 2006 =

Article ID: 906096

Article Last Modified on 10/24/2007

-

APPLIES TO


 * Microsoft Office Accounting Professional 2008
 * Microsoft Office Accounting Express 2008
 * Microsoft Office Accounting Professional 2007
 * Microsoft Office Accounting Express 2007
 * Microsoft Office Small Business Accounting 2006
 * Microsoft Office Small Business Management Edition 2006

-



INTRODUCTION
This article describes how to import master records into the following programs:
 * Microsoft Office Accounting Professional
 * Microsoft Office Accounting Express
 * Microsoft Office Small Business Accounting 2006

The steps that are described in the following section should be performed on the computer on which the company database is stored. If you want to import a file, you must have the Owner role assigned to you in Accounting Professional, in Accounting Express, or in Small Business Accounting 2006. Or, you must have Administrator rights on the computer.



MORE INFORMATION
Before you import data, you should know the following:
 * When you import a .csv file or an Excel (.xls) worksheet, Row 1 must be a header row that describes the data in the column. We recommend that you use the field name from Accounting Professional, from Accounting Express, or from Small Business Accounting 2006 for the header row value. Although you are not required to use this field name, the system will try to automatically map to that name.
 * When you import account information, the import file must contain the account name instead of the account number.
 * Accounting Professional, Accounting Express, and Small Business Accounting 2006 do not import an Inventory Asset account if the account has a non-zero opening balance against it.
 * If you first export data from other accounting applications, you may have to modify the data to make sure that the format is correct for importing. For example, if you export your data from Peachtree Accounting to Excel, you must reverse the sign (positive to negative or vice-versa) on all liabilities, income, and equity accounts that are in the Excel spreadsheet before you import the data into Accounting Professional, into Accounting Express, or into Small Business Accounting 2006.
 * You must import the destination account types in the following order:
 * Chart of Accounts
 * Vendors
 * Customers
 * Inventory Items
 * Non-inventory Items
 * Service Items
 * Employees

The following table shows the required fields for each destination account type.

How to import an Excel worksheet
The Excel (.xls) workbook may contain multiple worksheets for each type of data that you want to import; however, each worksheet or type of data must be imported separately.

There is a standard template for importing an Excel worksheet. The template is named ImportData.xls. The template is typically installed in the following location:

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

If you use the ImportData.xls template, you are prompted to save the file by using a different name. By default, the template file is configured as Read-Only, so you must create a new file. If you use this template, all the mapping is completed for you. If you use a different format, you must manually map the fields.

To import an Excel worksheet, follow these steps:
 * 1) On the File menu, point to Utilities, and then click Import.
 * 2) In the Import Data window, click Microsoft Excel Worksheet (.xls), and then click OK.
 * 3) In the Import Data Wizard window, click Browse, select the spreadsheet that you want to import, and then click Open.
 * 4) In the Options section of the Import Data window, select either the option to import duplicate records or not to import duplicate records, and then click Next.
 * 5) On this page of the Import Data Wizard, select the spreadsheet in Step 1, select the destination account type in Step 2, and then click Map Fields in Step 3.
 * 6) In the Map Fields window, you must map the fields from the Excel worksheet to the destination account type that you have selected in Accounting Professional, in Accounting Express, or in Small Business Accounting 2006.

Accounting Professional, Accounting Express, or Small Business Accounting 2006 will try to automatically map the fields that have the same name. If you use the ImportData.xls file, the mapping is completed for you. To manually map a field, select a field name that you want to change from the From pane, and then drag the name to the correct field name on the To pane. Asterisks (*) indicate required fields. When you map a field, a check mark appears under the Mapped column on the From pane. On the To pane, the mapped field name populates the Mapped from column.
 * 1) When you have mapped the fields, click OK, and then click Next two times to import the data.
 * 2) When the import process is completed, you receive a link to obtain the details of the import. Click Finish.
 * 3) Repeat steps 1-8 for each destination account type.

How to import a .csv file
For .csv files, a separate file must be created for each destination account type. However, you can import only one file at a time. To import a .csv file, follow these steps:
 * 1) On the File menu, point to Utilities, and then click Import.
 * 2) In the Import Data window, click Comma-Separated Values (.csv), and then click OK.
 * 3) In the Import Data Wizard window, click Browse, select the .csv file that you want to import, and then click Open.
 * 4) In the Options section of the Import Data Wizard window, select the appropriate option to import duplicate records or not to import duplicate records. Then click Next.
 * 5) On this page of the Import Data Wizard, select the .csv file in Step 1, select the destination account type in Step 2, and then click Map Fields in Step 3.
 * 6) In the Map Fields window, you must map your fields from the .csv file to the Accounting Professional, Accounting Express, or Small Business Accounting 2006 accounts.

To map fields, see step 6 in the &quot;How to import an Excel worksheet&quot; section.
 * 1) When you have mapped the fields, click OK, and then click Next two times to import the data.
 * 2) When the import process is completed, you receive a link to obtain the details of the import. Click Finish.
 * 3) Repeat steps 1-8 for each destination account type.

How to import an Access (.mdb) file
To import an .mdb file, follow these steps:
 * 1) On the File menu, point to Utilities, and then click Import.
 * 2) In the Import Data window, click Microsoft Access Database (.mdb), and then click OK.
 * 3) In the Import Data Wizard window, click Browse, select the .mdb file that you want to import, and then click Open.
 * 4) In the Options section of the Import Data Wizard window, select the appropriate option to import duplicate records or not to import duplicate records. Then click Next.
 * 5) On this page of the Import Data Wizard, select the table from the .mdb source file in Step 1, select the destination account type in Step 2, and then click Map Fields in Step 3.

For .mdb files, you can import only one destination account type at a time.
 * 1) In the Map Fields window, you must map the fields from the .mdb file to the Accounting Professional, Accounting Express, or Small Business Accounting 2006 accounts.

To map fields, see step 6 in the &quot;How to import an Excel worksheet&quot; section.
 * 1) When you have mapped the fields, click OK, and then click Next two times to import data.
 * 2) When the import process is completed, you receive a link to obtain the details of the imported date. Click Finish.
 * 3) Repeat steps 1-8 for each destination account type.

How to import an .xml file
Note You cannot import an .xml file in Accounting Professional or in Accounting Express. However, you can import an .xml file in Small Business Accounting 2006.

You can import an .xml file to import master records that have been exported from another company in Small Business Accounting.
 * 1) On the File menu, point to Utilities, and then click Import.
 * 2) In the Import Data window, click Microsoft Office Small Business Accounting Data, and then click OK.
 * 3) In the Import Data Wizard window, click Browse, select the .xml file that you want to import, and then click Open.
 * 4) In the Options section of the Import Data Wizard window, click to select or to clear the three check boxes as appropriate, and then click Import.
 * 5) When the import process is completed, you receive a path where you will find a detailed report of the imported data. Click OK.

Additional query words: MOA SBA

Keywords: kbhowto kbmbsmigrate KB906096

-

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

© Microsoft Corporation. All rights reserved.