A user sent this to me and thought it might be useful for those wanting to import using data from Excel.
"I found a CSV editor at this website:
http://csved.sjfrancke.nl/index.html that has an option to save all Alpha and/or Numeric data in Double Quotes. I opened my csv file that previously did not have the double quotes and saved it with this program and it automatically added double quotes to all alpha data. I found several other programs that would do the same. And I did some digging on Microsoft's website and found that there is no way to alter the default setting in Excel that restricts the program from adding double quotes to data without commas. Thanks for your help."
Hope you find it helpful.
Rob.