- Open up Notepad
- Type the following:
a,"This is some text"
b,This is some more text
- Save the file as "test.csv"
- Open test.csv in Excel
- Without changing anything hit CTRL-S
- When prompted to keep the workbook in csv format say 'yes'
- Close Excel
- Open test.csv in Notepad
Are the contents of the file the same as what you originally wrote? No? That's why you shouldn't open .csv files in Excel!
UPDATE, 16th Feb 2012. Today I have been investigating a problem with a file that caused errors during loading. After about an hour of pouring over a SSIS package on a wild goose chase the business analyst sent me this email:
<business user> and I got it to work
He was opening the file in Excel - which hid the fact that it had lots of commas in a row after the data. He looked at it in Notepad, removed the commas, and all was well
Need I say more!!