Link Query to Sharepoint

  • Thread starter Thread starter JT-TCP
  • Start date Start date
J

JT-TCP

I'm pretty sure I know the answer to this but i'm looking for more options...
I want to link an Access Query to Sharepoint so that updating one updates
the other. I know this can be done with Tables fairly easily. I'm under the
impression that an Append Query can link the other query and Sharepoint?
Also, don't you need SQL to do such a query? We do not have SQL so i'm
looking for other options if there are any...

Thank you!
 
I know this can be done with Tables fairly easily. I'm under the
impression that an Append Query can link the other query and Sharepoint?
Also, don't you need SQL to do such a query? We do not have SQL so i'm
looking for other options if there are any...

If you have a link to a list on SharePoint, then that behaves like a regular
plane Jane access table. You can open the table (well, ok a link) to view
the data, or you can fire up the query builder and use that table as the
source for that query.

So, what you ask should work just fine. You can append, delete, or build
queries usng that linked table as the source....
 
Thank you for the response. I, however, do not have SQL and cannot do the
append queries. Correct? So how would I link a Query in Access to a List in
Sharepoint? Can I create a query to pull data from one table and put it into
another table (that would be linked to Sharepoint) automatically?

Thank you.
 
JT-TCP said:
Thank you for the response. I, however, do not have SQL and cannot do the
append queries. Correct?

You can just use the standard access query builder to create that append
query. Nothing changes here due to the fact that you have a SharePoint
table.
So how would I link a Query in Access to a List in
Sharepoint?

You create a linked table to SharePoint, and then use the access query
builder to build a query based on that linked table.
Can I create a query to pull data from one table and put it into
another table (that would be linked to Sharepoint) automatically?

Yes. As mentioned, that linked table is not different then any other table
in ms-access except that it resides on SharePoint.

You need access 2003, and 2007 works even better. So, once you linked the
table to the SharePoint list, from that point on you can use the query
builder in ms-access. You can even write DAO reocrdset code and the source
table used for that DAO reocrdset code can be the name of the linked table.
So, your code, forms, queries, reports etc. can all be based on this linked
table to SharePoint, and from your point of view this linked table behaves
just like any other regular linked table.
 
Back
Top