Exporting data

You can take data entered in your MYOB company file and use it in other software or in other MYOB company files. This process is called exporting data.

Some of the types of information you can export are: accounts, items, general journal entries, inventory adjustments, Receive Money transactions, Spend Money transactions, sales, purchases, cards, jobs, timesheets, activities, and activity slips.

note : Exporting timesheets

When you export timesheets, only the entries that don’t have activity slips associated with them are included. You must export activity slips to complete the process.

The data can be exported to a tab-delimited or comma-separated text file.

note : Single-user mode required for data export

You cannot export data when more than one user is logged in. For more information, see Single-user file locking for special tasks.

Before you export data, you should make a backup of your company file. See Backing up and restoring company files.

To export data

1	Go to the File menu, choose Export Data and then choose the type of data you want to export. The Export File window appears.

2	Select the export file format and enter other information in this window. For detailed field help, see Export File window.

3	Click Continue. The Export Data window appears.

4

Choose the fields you want to export and the order in which you want to export them. To do this, click on the first field you want to export in the AccountEdge Fields column. Field 1 will appear in the Export Order column next to the field you selected. The field name will appear at the top of the Export Fields column on the left side of the window.

5	Repeat the previous step for each field you want to export.

If you want to remove a field name from the Export Fields column, click the name in the AccountEdge Fields column. If you want to export all the fields in the order they’re shown in the AccountEdge Fields column, click Match All.

6	When you have selected the fields, click Export. The Save As window appears.

7	Enter a file name and location for the export file and click Save. The file is exported.

Related topics

■	Import and export fields

■	Exporting to and importing from CaseWare

■	Importing data

■	AppleScripts