sync sharepoint with excel file

Hi,

just wondering, how does the content of this excel file gets changed? If it is an automated process, is this excel file used for anything else? If not, why don't you update your sharepoint instantly without going through the hassle of using the excel file to update a list?

In case you do want to do this, you'll have to create a custom timer job that reads the excel file every 5 minutes.
http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx

I want this because i hava a time attendance machine to log the attendance for employee, the report is export to excel file, i create a bat file with shcedule task to each 5 minute import the report from the time machine.
So each 5 minute the excel file change.
i want to allow sharepoint to import the data in a list .

You can add that excel file in the Central admin--shared service --under excel services, choose "Trusted file location" and add the excel file as a trusted file

After that use a "excel viewer webpart" and configure it use the excel file in question as referance.

@yagyashgree- that is still not going to update his file every five minutes.
@spring80 - Out of the box you cannot update a SharePoint list automatically from an excel file. You have a couple of options to update the SharePoint list. One you can literally open the excel document that is linked to the list and tell it to update the data, however you would have to do this every five mins or write a macro to do it for you. You do need to follow yagyashree's steps to setup the connection.  Second there used to be a add in from Microsoft http://msdn.microsoft.com/en-us/library/bb462636(v=office.11).aspx however your file has to saved as an Excel 97-2003 file extension and I am not sure it still works. Your best bet is to use Access to accomplish your needs if you must have a SharePoint list. If you don't have to put the data in a SharePoint list and can keep it as an excel file then look at the link below. Here is some light reading regarding the issue: http://technet.microsoft.com/en-us/library/cc262899(office.12).aspx .

ok it is better from access, because i can extract the file from time attendance with accdb format.But when i need to link the database to sharepoint ,there is a problem "could not lock file" message appear .
So if it is more simple to use access database, can you told me the step to accomplish my goal ??

regard

Is the account you are using have write access to the database file.

now i connect the database to sharepoint , but when a new item create in the database, is not update in sharepoint list .Any idea?

i receive this issue :
SharePoint does not support unique indexes on any column other than ID.

Take a look at this link scroll down towards the bottom and it will tell you what SharePoint allows when moving tables. http://office.microsoft.com/en-us/access-help/move-the-tables-in-an-access-database-to-a-sharepoint-site-and-link-to-them-HA010131468.aspx?CTT=3 

Also take a look at this link: http://sharepoint.microsoft.com/Blogs/GetThePoint/Lists/Posts/Post.aspx?List=8d9e2a99%2Df288%2D47c2%2D916b%2D2f32864f7b82&ID=68&Web=5e4647a0%2De7d0%2D4626%2Db71c%2Db1ff06402465 

i create a sync link between sharepoint and access .
So i have before one table in my database is : acclog
i link to sharepoint list name time attendance .
so now i have 2 table in my database : 1- acclog 2- time attendance (yellow color with plus sign)
so if i create an item in time attendance table ,it will be create in sharepoint list " time attendance."
But now i want to sync between the 2 table in access so the same data should be in it.
So if any new item arrive to acclog table ,it should be sync directly to time attendance table.

How can i do this sync ??

Regards

If I am not mistaken open up the database and on the status bar there should be a button that may say offline with sharepoint and click it to sync.

sir, all these button is disable (synchronize now , linked table manager , work offline , discard change , synchronize , cache list data)

i am using sharepoint server 2010 and microsoft access 2010

Dear Sir
Really i read this many time before ,but the button which have the ability to do the synchronize is disable, any methon can't success

All hte button from sharepoint list in microsoft access is disable except Relink list

Please check the attached file
sharepoint.jpg

You will have to synce from the table that is linked which from your picture is the Time  Attendance table.

Rebecca

the same thing , but if i use other databse ,it is work fine , and if i use the convet command from current database it work fine also , but the time attendance machine not work with accdb database, it is work with mdb database.

So can i allow the sharepoint to sync with mdb access database ??

I believe it needs to be a mdb file.

It works