Using Access 2013, downloaded "Desktop inventory" template.
Have successfully added inventory items to database (so all my item numbers are known).
I'm trying to import an XLS containing inventory transactions, so goods in/out of my stock can be scanned with barcode to an Excel sheet first (scanned barcode need to be stripped for extra digits before import). I simply cannot make it work!
I've tried with a blank new database, changed format on columns in my XLS, named colums differently etc. Either I get a "Subscript out of range" or "Property not found" error.
I would be grateful if someone could try to create a new database using the same template and then see why it's not possible to import an XLS via the "External Data" import button on the ribbon.
Thanks a million for your help - it's driving me insane!
And I guess there is no need to say I'm not Access experienced in any way! :-)