I have a list in sharepoint that is created from Access by using the export. The data in acess Access is a linked table to sql server. Now I have new data in sqlserver which I want to exisiting list in sharepoint. How would I do that ? Thanks

It helps to know which Access and which SharePoint in cases like this. There are ways to create a SharePoint List from an Access table which mean that the SharePoint List is synced with the Access Table. I.e. changes made in the Access table are reflected in the SP list. If your Access table is being updated from SQL Server than those changes should also (in that case) be synced to the SP list. BUT if you have used one of the methods that just create a SP list from an Access table (i.e. a List that isn't synced with the Access table) then you are out-of-luck and would need to re-do your list creation (using a method that will sync) SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters

I used MS Access 2007. In that I used "export to sharepoint" feature to create a list in sharepoint. Can you point to me an example that uses sync method? Thanks

I have a couple of chapters on Access with WSS 3.0 (with MOSS 2007 it's the same) in my 2007 book so I've just gone to that for the following info. (If you have access via Safari it's pages from page 269). In brief there are three options starting from the Access table which are a) create a copy; b) create a new list; c) move an existing list. These are misleading terms ! a) is probably what you have. You use menu item External Data and there to the Export part of the Menu area and click the SharePoint List link. Synchronization doesn't work. b) Create a WSS 3.0 List when in Access 2007. This too is misleading as this is the sole option of the three that start from Access 2007 that provides synchronization. When in Access 2007 -> Create > SharePoint List. Synchronization does work c) Move an existing table This seems to be a clear description. The table is moved ("Move to SharePoint" on the far right of the External Data menu) . However the database table is now stored in the *SharePoint server* and so it can be accessed *there* by using Access 2007 and any changes made in Access 2007 can be "published" to the version of the database in the SP doc lib. But this won't be suitable for you as the location isn't your original location that gets the updates from SQL Server. I suggest therefore that you look closely at option b) - the badly named "Create a SP List" My Note on page 273 said "Full synchronization is acheived only if you start with an existing WSS 3.0 list and make an Access table from it (or create a new SharePoint list while in Access 2007, which has the same effect)." Hope this helps. SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters