Check Spreadsheet Format
Make sure all cells are formatted as text. Don’t set any columns to special formats like DateTime or Currency.
Excel 2003 Users
I believe there is a Sharing Violation bug with Excel 2003. If you have your spreadsheet open in Excel 2003 and try to import at the same time, you are likely to get this error. Close Excel before attempting to import the spreadsheet.