Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Writing to SharePoint list 2010 from Ms access

Writing to SharePoint list 2010 from Ms access

Writing to SharePoint list 2010 from Ms access

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.


RE: Writing to SharePoint list 2010 from Ms access

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.

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


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close