Update back to shaprepoint list from dowloaded Excel file

A

Amitabh

Hi

I am having a client requirement that user can download Excel/Access file
from SharePoint list, do some changes in Excel/Access file and upload it back
to the same SharePoint list. I am working on <b>SharePoint 2007</b> and
<b>Office 2007</b>. A user is not able to see all the records in his view,
filters are applied on <b>Assigned To</b> column condition is <b>Assigned To
= [Me] </b>on View.

I am using <b>Export to spreadsheet</b> option present inside <b>Action</b>
Menu at top of Sharepoint list. But When I opened the downloaded Excel file,
I found that it can only be Refresh from SharePoint list but cannot be
updated back. An Export option is in there in Excel but that creates a new
SharePoint list which is not my solution.

<b>Open in Access</b> option is also in there but it returns me all records
present in SharePoint list, some of the records I dont want a particular user
should be seeing or editing.

Can anyone help me by telling Is there any way to update back changes to
same SharePoint list ? I am ready to write any code to achieve this
requirement.
 
Top