I am using a datasheet view in sharepoint to manage an excel like sheet that multiple users can modify there data in. right now i export the list manually and upload it to the service provider. I am looking to automate this routine and looking for suggestions and even an example if someone has done it.
In the past I would do a SQL query, however we all know sharepoint is structured a little weird.
My goal is to automate the process end to end and take the middle man out of someone doing the upload piece.