Hello, I have a list in SharePoint and unfortunately do not have sharepoint designer enabled to create this through a workflow. I'm trying to think of a work around using MS Access to bulk upload documents (this can be done in sharepoint) and then in access write queries or something that populates the associated metadata from the file name into each column.

E.g. Column: Document Name; Value: 00000Jane2018.
Column: Number; Value; 0000
Column: Name; Value; Jane
Column: Year; Value: 2018

The queries will populate all the columns above based on the document name values



Any ideas are appreciated, thanks!