import excel data to sharepoint 2010
Posted on 2011-09-06
resonably new to sharepoint 2010 development and have been tasked with converting a large spreadsheet for pricing into a sharepoint system. Problem I have is taht when i use the sharepoint Create List from Excel data import routine, sharepoint insists on making some of the columns into Multi Line test fields EVEN THOUGH the data is at max 80 chars in length. Is there a trick to this? How can I force the column types on the import?
Is there a way to create the list first and then import the data to the existing columns?
I'm sure i'll have lots more questions on this project so be prepared :P