How to import data into SharePoint 2010 List
My problem was how to migrate some lists from SharePoint 2003 into SharePoint 2010. There is a simple and effecitve way how to do this. At first you have to export data to Excel file. The next step is import Excel data into SharePoint 2010 list. How to do this, you can find very well described in this post:
There is one thing I will add to this post. What I liked with this procedure is the fact, that the import function automatically finds the right data types for columns (text, number). Only with the text columns it alway selects “more lines of text”.