This question has been asked before but I haven't found an answer that works for me and my limitations.
I have an excel spreadsheet that is currently being used to input data with 20+ records each time. I want to be able to import this data into an existing sharepoint list. I'm using office 2010 and SP 2013. I don't have Visual Studio so I'm looking to do this with VBA or out of the box.
So my idea right now is to create a new worksheet in the workbook with the formatted data, then upload the workbook to a document library in sharepoint and run a workflow that would then take the (hidden) worksheet with the formatted data and update an existing sharepoint list. Is this possible without visual studio?
Alternatively I could import the data to access and then link my access DB to a sharepoint list?
I haven't really gotten too far in my research on any of these scenarios yet so I was hoping I could get some insight before wasting a week finding out what I can't actually do.