Adding a large amount of new inventory

SUGGESTED

We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location.  What is the most efficient method to add this information?  I have attempted to create an Excel spreadsheet to import the data (4 different times into 4 different screens for the different tasks) but I keep getting an error message stating "The Microsoft Access database engine cannot open or write to the file ".  It is already opened exclusively by another user, or you need permission to view and write its data."

What am I missing in order to get these files ready to upload?

Thanks,

Lisa

Parents Reply
  • 0 in reply to Jay Converse Acumen

    I have it happen sometimes on templates I use all the time where "something" changes and then it does recognize the ITEMS tab.  and you can't just manually rename it.  it can just be a glitch (even though I don't really believe in glitches... )

    Only solution is to create new template like you say.  Hasn't happened in a long time for me, but it used to happen a few times here and there.

Children