Showing posts with label Access. Show all posts
Showing posts with label Access. Show all posts

Tuesday, April 5, 2011

Executing SQL commands on SharePoint List

Hi Folks,

Some times you need to run some SQL commnads on a SharePoint List trying to copy some content from one column into another ... etc.

The solution for this is Microsoft Access (2007/2010), simply create a new Access database.
Type the list URL:
Then choose the List you want:

Then create a new Query:

Then Run the query.

And it will update the List inside the SharePoint portal.

Happy programming!
Saed