Populate Sharepoint 2007 list Excel 2007

I am still fairly new with sharepoint but now have a good grasp of sharepoint basics. I am creating a new site in sharepoint for a user within our company. The user has has existing data in an Excel 2007 spreadsheet. In the sharepoint list I have same columns as in the excel spreadsheet. What I want is to export the existing data in the excel spreadsheet into the new sharepoint list. Please can some help on how I can I achieve this using OOB sharepoint.
iCandoallAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllisterCloud ExpertCommented:
In MOSS 2007 you can update lists from Excel (they took this away with later versions).

So, you should be able to open the list in Excel, and paste your values into the spreadsheet it shows you (with values from your other spreadsheet).

You can also paste values into lists via the Datasheet view. (Haven't used 2007 in a while so don't remember what you press to get Datasheet view, but it should be fairly obvious in the options).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
iCandoallAuthor Commented:
Thanks Jamie for your comment. I have managed to  populate the list using an addin for excel which allows data to be publishes to a new sharepoint list. Basically, from the Design tab in SharePoint 2007 there is a tab that allows the excel to create a new list complete with required columns.
iCandoallAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for iCandoall's comment #a39752223

for the following reason:

Comment is alternative solution to my question
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Jamie McAllisterCloud ExpertCommented:
This question should be marked as answered, not closed.

The user solution of creating a list from Excel differs from the question that states that a list already exists with the required columns.

Can I suggest post 39751032 gets at least some partial credit for answering the original question?
KoenVostersCommented:
Jamies answer in all honesty is an answer to his question.
iCandoallAuthor Commented:
I am not understanding what all this chaos is about regarding this. I did not use Jamie's solution coz I could not understand it, but found another way of solving the problem. Is it the points you guys are concerned about? do you get paid by the points you collect or what because I do not understand this? If its the points you want you can have them.
Jamie McAllisterCloud ExpertCommented:
iCandoall, I sense some misunderstanding about the purpose and use of this forum, so please allow me to explain.

The people answering questions here are unpaid volunteers. Motivations vary for the experts, but in general they are driven by customer satisfaction, contribution, and kudos.

Customer satisfaction is achieved by the questioner getting what they need to make their day job easier. Contribution is achieved by having the answers saved for future users of EE to refer to without them having to ask the same question again. Kudos is gained by the competition between experts to answer more than the other experts, represented by points.

In this thread, a valid answer was being deleted and no points awarded, which negates two of the three motivations listed above. This is why we felt the need to comment that the thread should not be deleted.

I'm sorry if you didn't understand the answer I provided, though the forum is interactive and I'd be happy to respond with clarification if asked. I'd appreciate it if I could be awarded some points for post 39751032 which I feel answered your original question, and may help others in the future. That is entirely up to you however, I won't lose any sleep if you don't.

Kind regards, and I hope you continue to get your questions answered on EE.
iCandoallAuthor Commented:
Hi Jamie

Thanks for your comment. You can have the points. What am I supposed to do for you to have them? I appreciate you willingness to help in my original question, if experts decide not to answer my questions I ask, unfortunately there is not much I can do.
Let me know what to do so you can get points.

Regards
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.