Linking pre-existing MS Access tables into a SharePoint list

Question

Problem:

1. I need to import data from an Access Database and generate metrics / charts based on it
2. Business Connectivity Services is not available to me
3. Data needs to be as "real time" as possible
4. Access Services is not turned on
5. Performance Point / SQL Server 2012 - not turned on

My only thought: Somehow "link" the pre-existing Access tables into a number of lists on the site collection. I could then utilize those lists to generate metrics using chart web part / data view web part.

Problem 2:

1. MS Access only "links" to lists that are already on SharePoint
2. Tables within MS Access can be "exported" to SharePoint but no relationship is maintained
3. Exporting an existing list and then "linking" to it creates a new table and does not maintain the relationship with the existing table.

Any thoughts would be greatly appreciated!

Answer 1

Hi Shrout1,

Please check the following article about How to Synchronize Excel 2010 + SharePoint 2010 List with Excel 2007 Add-In, you need to move your Access data to the Excel file previously,

http://sharepoint.microsoft.com/Blogs/GetThePoint/Lists/Posts/Post.aspx?ID=589

Thanks

---

Daniel Yang

TechNet Community Support

Answer 2

Bummer; it would be nice to retain all the client functionality in the existing database without having to export and rebuild it.

But I do appreciate the response!