Best practice for taking Excel Data to Sharepoint
Posted on 2014-07-22
I have a problem that I'm keen to get some advice on the best way to approach.
I'm building a model in Excel to capture information using controls and forms (eforms) the data is pulled through to a capture/summary worksheet that holds all the required fields for the SharePoint list (this can run top down or left to right - from what I've seen so far left to right is how it needs to be for SP).
With the data I'd like to export it into a SharePoint list once the user (there are many potential users) when they hit submit . The 'case' that they'd complete would then populate the next row on the SharePoint list.
The version of SharePoint that I'm using is 3
The versions of Excel are 2003 & 2010
Obviously I'm somewhat open to suggestions but does this sound feasible any tips on the best way to approach the issue or online resources to assist.