Error when importing spreadsheet, Sharepoint

Never done it myself, but perhaps you could combine this code which programmatically creates the basics of a survey with this code which adds the questions. It shouldn't be too hard to do some sort of mail merge to convert your user's spreadsheet into code which will create the questions.

Actually, multiple connections to the same AD is not supported...see the comment below: Currently we only support "one AD-Connection per Domain and Forest" at a same time! You must configure the entire connection for all OU's and objects you want to import(or export like the thumbnailPhoto) within the same domain and forest on one single AD-connection! Multiple connections to the same Domain and forest at a same time are simply not working!

Example: You have configured an AD-Connection to your Domain "MyCompany" by chosen the OU's for "NA-Users", "EU-User" and some others. Later on you decide to add another AD-Connection against the same Domain but now having only for a specific OU within the same forest to use the "Export profile picture from SharePoint to AD"

Result: You'll not get any pictures updated on the AD as this does simply not work. You must change the previous created AD-connection and modifying the property mapping and/or adding additional OU's to be synced within "one single AD-Connection".

THE LINK IS - http://blogs.technet.com/b/steve_chen/archive/2010/09/20/user-profile-sync-sharepoint-2010.aspx