Link to home
Start Free TrialLog in
Avatar of nnrsc
nnrscFlag for United States of America

asked on

Export from Access 2007 to SharePoint 2010 List

I intend to use the Export->SharePoint List function in Access 2007 to publish query data on my SharePoint 2010 site. This is going to be a weekly effort.

A problem I noticed during my testing is that every time I do the exporting, a new list is created. For example, at 10am, I Exported the query. The report name on my SharePoint site is MyReport. This is good. At 11am, I did another export, a new list name MyReport_1 was created, instead of voerwriting the existing MyReport which was done at 10am. (Please understand this are just my testing of how the function works. In reality, I will export on weekly basis, not hourly.)

What I want to achieve is to replace the existing SharePoint list so that every time a user comes in, there is only one list MyReport showing up. Is it possible?

Thanks...
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nnrsc

ASKER

Awesome. I was able to make it work exactly as you said. Very appreciate it!
Avatar of fatalblitz
fatalblitz

Hi Dale, I have a question similar to this but instead I'll have 16 different tables linked to seperate SharePoint sites (all from one "Prototype" database). This prototype database gets it's data from a "Main" database, in which I have make_table queries to create these tables and place them into the Prototype DB. The Query is:

SELECT * INTO table_CES IN 'C:\Users\UserName\Desktop\Prototype.accdb'
FROM [SKILL AREA VR - All Info CES];

I currently have Access Services and SharePoint Designer disabled in my environment, so my question is are there any ways to have a 3 way linked connection between Main (Access) -> Prototype (Access) -> SharePoint (tables) so that the make_tables queries won't be required?

I've tried to create a link between an Access -> Access database, and link one of those tables to SharePoint, but the connection between the other access database breaks. Which is why I have to have this workaround.
no way for a "3-way link",

What i the purpose of the Main and Prototype databases?  Are you just trying to replicate the data between the main database and the Sharepoint list?

You might get a better response to this if you posted a new question, so that others with Access/Sharepoint can provide their input as well.  If you do so, post a link back to this question so they can see the original question as well.
Yes, I guess you can say the purpose of having two databases is the prototype's purpose is to just house the 16 linked tables, plus the 16 "made" tables to append off of. The main database is full of queries and other tables already. Okay, will do! Thanks
When you post the new question, you need to give a better explaination of the purpose of the Main, Prototype, and Sharepoint lists.  Where the "application (front end)" of the application sits in relation to these, and the purpose of the 16 tables.