Hi, i created a list in MOSS 2007, 4 columns are present name, psnumber,old comment,new comment whenever i do new item i fill only 3 fields ,old comment is optional. my requirement is old comment field shud be import from my excel sheet old comment column is it possible . Please help. sudhanshu sharma

Did you check this one: http://blog.techgalaxy.net/archives/825 or http://rawatsumit.blogspot.com/2009/09/tips-and-tricks-importing-excel-sheet.html hope this help thanks -wsThanks -WS SharePoint administrator, MCITP(SharePoint 2010)

Hi , I am doing by these 2 links only. 1st i got a error which is mentioned in 1st blog ,i resolve tht after that while importing i am facing this issue(dialogue box-the specified list name is already in use on this server .you must rename the list before publishing it to the server.) . i tell you exact steps which i did- i created a list in moss 2007 name ImportList, 4 columns-names(rename to title),PS Numbers(numbers field),old comment(multiple lines),new comment(multiple lines),only old comments is optional rest all fields are mendatory. i have excel in my local(D drive)having columns-name ,psnumber,old comment and some more n different column. My require ment is when someone enter data in sharepoint list he can left old comment column as i want this column should be import from my excel sheet column old comment. i follow steps in given blog- first i get lOWSPostData failed error i resolved this by given steps ..n continue with my excel selection but as i click on import i got this dialogue box msg(mentioned above). Please guide what to do ? Thanks for your help. sudhanshu sharma

one more thing ...i got one thing that we cant import one column only every tim ewe import selected excel as alist...so now i m getting my new list. can it may possible that the list name override every time new list creation should not be done.sudhanshu sharma

Hi, When you are importing an excel sheet you need to provide a list name not already existing. In the other way you can choose the option of edit in datasheet for the list and then you can copy entire contents of the excel sheet and then you can just paste it to the list and it will work for you. I hope this will help you out. Thanks, Rahul Rashu

hi rahul, Thanks I have got the answer :)sudhanshu sharma