THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Excel » csv   (RSS)
Sorry, but there are no more tags available to filter with.
  • Why you shouldn't open .csv files in Excel

    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-SWhen 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 ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 2, 2009
Privacy Statement