?
Solved

Sharepoint list - import and append

Posted on 2012-04-10
2
Medium Priority
?
523 Views
Last Modified: 2012-04-11
Is there a method I can use an existing spreadsheet to add a batch of new items to a pre-existing SharePoint list?
0
Comment
Question by:K_Deutsch
2 Comments
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 1000 total points
ID: 37830134
If MOSS 2007 you can open the list with Excel, make changes and save.

If SharePoint 2010, not with Excel - no longer supported.

You can use MS Access to edit and add items to the list in 2010. When in the list view, the ribbon should have a open in Access button. (It also has an open in excel button but it's read only).
0
 
LVL 2

Assisted Solution

by:ArticalBadBoy
ArticalBadBoy earned 1000 total points
ID: 37831506
You should be able to perform this action in both SharePoint07 or SharePoint2010 if you download and install “Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists” to your copy of Excel 2007/2010.

In the case mentioned, it will be a little more complicated though, as from my understanding you have already got a sharepoint list, and ALSO a spreadhseet ith additional data.

You would need to export the current list as a spreadsheet; ensure it was a table, then copy and paste the data from the other spreeadheet into this newly exported one, and then syncronise back into SharePoint. You need the Add-in toget it syncronised back into SharePoint.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question