Connect Excel to SharePoint via Access 2010

[dunaDMM]

Hi Team,
I am trying to figure out a way to connect an Excel sheet to SharePoint list. Right now, I have a table in a Access file that is connected to a SharePoint list. And another table in the same Access file that is connected with Excel. But there is no connection between the Excel and the SharePoint list because the tables in the Access file are not connected.
Is there a way to solve this?
Thanks !

 

[Andrew Poulsom]

Maybe this will help you:

Import data from a SharePoint list - Excel - Office.com

 

[dunaDMM]

Hi Andrew,
Thanks for the answer but I’d like to have the files synchronized, so if I have some update in the Excel file it will be passed to the Access and then to the SharePoint List. The original data is an Excel File.
I know there is an Add-In to allow this synchronization directly between the Excel and the SharePoint, but it is slow and not stable.
So, I am trying to do that through Access to make this faster and more stable.
Do you think this is possible?
Thanks a lot!

 

[Andrew Poulsom]

Is this the Add-In you are referring to?

Restoring Two-Way Synchronization on SharePoint Lists Using Excel - CodeProject

 

[dunaDMM]

Hi Andrew,
Yes, this is the Add-In.
It works, but according to my tests, it takes about 40 seconds to update the Excel file when I click on Table -> Synchronize. The table is quite big, about 33000 lines.
So i am trying to figure out a way to speed up this.
Thanks,
Douglas.