I wouldn't open the CSV from the common dialog. Use the import from text in the ribbon. Ensure that your columns are of type text.

-Josh