I would like to append a SharePoint List Programmatically through VBA.



The process is as follows:

1. Compile and Manipulate Excel Files.
2. Add Data to Access Table
3. Upload Data to SharePoint


I can accomplish 1 and 2 on my own. Need help on #3

I do not want to link the table. I want to write the items to the List.

I have found some documentation online, but don't think the information provided is exactly what I'm looking for... ideally I could do this all from an Access Form and use different library references for other programs to accomplish my task.

Here is some of the information I found:


Use Soap? - http://archive.oreilly.com/pub/h/1306
Use SOAP MSXML - http://blogs.msdn.com/b/jpsanders/ar...place-stk.aspx
Use C#? (This looks promising not sure how to use it though....) - http://www.mindfiresolutions.com/Add-Update-and-Delete-List-Items-Programmatically-in-Sharepoint-372.php

Thorough Explanation (Code Commenting) what be appreciated seeing as I'm new to the SharePoint Animal.....