Part Number Interchange

Part Number Interchange replaces part numbers during a Save As export using an external lookup file. This is useful when you need to publish the same applications under a new numbering scheme — private label, brand consolidation, or supersession lists.

After you choose a file name and ACES version in File > Save As…, AceViewer asks “Apply part number interchange?”. Answer Yes to launch the wizard. Answer No to skip it and export with the original part numbers.

Supported lookup files

• Access (.mdb / .accdb)
• Excel (.xlsx)
• Delimited text (.csv / .txt) — tab, comma, or custom delimiter, with optional quoted values

The wizard

The wizard has two pages:

1. Select File — browse to the lookup file. For Access files, pick the table you want to use. For delimited text, choose the delimiter (tab / comma / other) and whether values are quoted. A preview grid shows the first rows so you can confirm the file parsed correctly.
2. Map Columns — choose the lookup column (the old part number to find) and the replacement column (the new part number to write). The status line shows how many usable mappings were found.

All rows vs. matched only

The wizard’s export options control which applications end up in the output file:

• All rows — every visible application is exported. Rows that have a match in the interchange file get the replacement part number; rows without a match keep their original part number.
• Matched only — only applications whose part numbers exist in the interchange file are exported. Use this when you want to publish exactly the subset that the interchange file covers.

The Save As completion message reports how many applications were saved and how many part numbers were replaced.