Import From Microsoft Excel

This procedure walks you through the process of importing data into Office Accounting from an Excel workbook. The workbook may contain multiple worksheets for each category of data you wish to import, but each worksheet must be imported separately.

Office Accounting recommends that you use the ImportData.xls template installed with the product for importing your data. By default, the template is installed in the following location on your hard drive:

C:\Program Files\Microsoft Small Business\Office 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:

1. On the File menu, select Utilities.
2. Select Import.



3. In the Import Data dialog, select Microsoft Excel Worksheet (.xls) and click OK.



4. In the Import Data wizard, click Browse.
5. Navigate to the spreadsheet you want to import.
6. Click Open.
7. In the Options pane of the Import Data window, select either the option to import duplicate records or not to import duplicate records, and Next.
8. On the Select Destination Account Type page, select the appropriate Excel Worksheet in Step 1, select the destination account type in Step 2, and then click Map Fields in Step 3.



9. In the Map Fields window, you must map the fields from the Excel worksheet to the Office Accounting destination account type that you have selected.



Note: Office Accounting tries automatically to 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.

10. Finish mapping the fields.
11. Click OK.
12. Click Next.
13. Click Next.
14. Click Finish.

    

15. Repeat steps 1-14 for each destination account type.