Okay, apologies up front for I am not a DBA by any means but I have never had such problems trying to import data in my life, I'm hoping someone here can help me out with this one.
I have an Excel spreadsheet with the following information in each row:
ResponseID, Response1, Response2...