Got excited when the Excel 95 format of the import file containing 8,000 items seemed to work, but afterward discovered that some (seemingly randomly) of the items were duplicated with truncated item codes and truncated descriptions. An example of this would be an item code 250-134-09 that was properly imported also showed up in the database as a separate item 250-134-0, the latter of which is a total non existent item. Too many items ended up this way - restored the Inventory backup and am back to the drawing board.

Interesting that Adagio is using Excel itself to do the import. BTW, the site is using Windows 7 and MS Office Excel 2007. (but I've tried this in WinXP - same result).

A real head scratcher...