When doing an insert, how can i merge one field from multiple records in a table but not the other fields?

For example, we are rewriting our application in vb.net using sql server. On the data transfer we have a customer comments table which we need to import. The format for this is

CustNo Comment (varchar30)
------- -------------------
1 aaaaaa
1 bbbbbb
1 cccccc

and what we need in new app is

CustNo Comment (Text)
-------- --------------------
1 aaaaaa bbbbbb cccccc

Any ideas?

Thanks
Steve