Solved

Sharepoint list - import and append

Posted on 2012-04-10
2
511 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 31

Accepted Solution

by:
Jamie McAllister MVP earned 250 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 250 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now