Export and import company records from one company file to another
Description
Cause
Resolution

Export the list in a text file

  1. Go to File, Import / Export, Export Records.
  2. Select Export records to a Sage 50 import file format.
  3. Click Next.
  4. Select the record type you wish to export (for example Vendors).
  5. Enter a name for the export file.
  6. Enter the location where you want to store the file.
    • Click Browse to go to the location, then select OK
  7. Click Next.
  8. On the Select Records window, select the records you wish to export.
  9. Click Next to generate the export file.
  10. When exporting is complete, you’ll see a summary.
    • Verify that the data is correct
  11. Click OK.
  12. The Export Wizard will show you the location and name of the exported file.
    • Note this information
  13. Click Finish.

Example of an exported text file

Exported text file example.

Import the text file into the new Sage 50 company file

  1. Go to File, Import / Export, Import Records.
  2. Select Sage 50 import format and click Next.
  3. Create a backup of the company file before importing.
    • Select Back Up and follow the wizard's instructions
  4. Select Next after the backup completes.
  5. Click the Browse button next to the boxes you wish to import.
  6. Select the files you previously exported and click Open.
  7. Click Next.
  8. Sage 50 will display all the added records.
  9. Click OK and Finish.
Steps to duplicate
Related Solutions