Writing to SharePoint list 2010 from Ms access

[101287]

Need guidance and/or code example. Need to create macro in MS access 2010 that write to a sharepoint 2010 list.
For example, a table is update in access once the table is updated a macro needs to be trigger to add item in a sharepoint list.

Your guidance will be appreciated.

Luis

 

[ehaze]

You can link to a SharePoint List.

*Access 2010. External Data tab --> More --> SharePoint List*

Then run your macro against the SharePoint List.

To update the List, you will need to create an Update Query.

More or less, the List will act just like a normal Access Table.

**warning**
If the SharePoint List has any SharePoint Workflows associated with it, running your Update Query in Access will start the Workflows.

http://www.sharepointed.com/