Assistance in solving errors for an Access Database

I need help in understanding issues I have with a database created by someone who previously worked at my place of work.

I currently work for a company which provide uniform and PPE products to engineers along with tools as well.

For some context, the database in question is used for mobilisations of goods by importing a spreadsheet containing data for each engineer and their location. In the fields for the engineers will be uniform mainly and sometimes toolkits and PPE kits. The uniform is split into SKU, description, sizing, colour and quantity.

It is in the spreadsheet import where one error is occurring. Due to the number of different items we are trying to import this time, some trousers have been added in the additional items columns. When importing it doesn't seem to pick up the sizing or colour on these which creates a problem when printing signing sheets. I have tried adding in columns for trousers but then the spreadsheet won't import due to some formatting error.

The other issue is that the blouses would not export to SAP but they are clearly in the database as you can see in table "New V2 Mobilisation Table" which it seems might be another import/export error with the database not recognising the product code maybe?

Is this something you are able to look into today as this is an urgent matter for us?

I have attached the spreadsheet for the import. If you are able to look at this today please let me know and I will send the database over using wetransfer as it is too large to attach to this.

Thanks

Tom Eastwood