Yes.  Enter a value through the Delete Change Items screen, then look at the raw data (DFDM / ODBC...) to see what values you need to set in your VI job.

I always set Starting and Ending fields to the same source data to prevent mistakenly selecting a range.

Sorry, can you direct at best way to view raw data?

DFDF = Data File Display and Maintenance - Library Master - Utilities menu.

Try this in a test company first.  From my experience, this process can take longer than you might expect.  Try it with 50-100 items to get a feel for the amount of time it will take to complete the renumber process.

Excel query of the table works to view the raw data.

I agree completely with Bshockley's advice to try in a test company first, with a limited number of items.

Your source file should have just two (2) fields. The Current Item Number which is used for both the Start and Ending Item Code fields and the new item code used for NewItemCode

I tested it in a test company and it does place the information into the Inventory -Utilities-Delete and Change items table for further update which is what I expected. BUT it only adds the last record even though it says all 3 items were imported. Any thoughts on why its only the last record?

I think you need something like this, or have a column in your spreadsheet for the LineNo.

That did the trick Kevin M! Thanks!