Active Vendor Viewer: Importing from a Spreadsheet

You can drag and drop spreadsheets into the Active Vendor Viewer to add vendors to, or change vendors already in, Vendor Maintenance. For example, you may create a spreadsheet of new vendors to add to Vendor Maintenance. Or, you may export Eagle vendors to Excel, manipulate those vendors in the spreadsheet, and then import the spreadsheet back into Eagle via the Active Vendor Viewer.

1. Once you have created the spreadsheet you want to import, drag and drop it into the Active Vendor Viewer.

The system automatically looks at the column headings in the spreadsheet, and asks you how you want to match up the import to those column headings.

2. Click the relevant columns to match. If you are changing existing vendors, leave the default of "Discard non-matching rows." If you are adding vendors, select "Add non-matching rows."
3. Click Import.
4. If a list of non-matching rows displays, click OK.
5. The system automatically places a check mark in the box of vendors that matched the criteria in step 2.
6.  Make any desired changes to the checked vendors.
7. Click Change to save.