None of the aforementioned solutions worked. I went into the Paste from Excel screen and formatted the columns to match my spreadsheet. I pasted 1292 rows in that screen and it worked. So I now have my inventory in. In case anyone reads this post for the same issue I had, don't bother with trying to get the import to work for Inventory parts (non-inventory parts worked fine). Do the copy/paste option.
