Hi i want to import a csv file into excel . the file is imported but it does not put the comma separated values in different columns . Any help would b appreciated :) heres my code
                Excel.Application xlAppl;
            Excel._Workbook xlWB;
            Excel._Worksheet xlSheet;
            Excel.Range oRng;

                xlAppl = new Excel.Application();
                xlAppl.Visible = true;

                xlWB = (Excel._Workbook)(xlAppl.Workbooks.Add(Missing));
                xlSheet = (Excel._Worksheet)xlWB.ActiveSheet;

            //Add table headers going cell by cell.
                 xlAppl.Workbooks.Open(@"d:\csvtest.csv",false,fals e,5,"","",true,Excel.XlPlatform.xlWindows," ",true,false,null,false,null,false);

Are the commas present in the file?
Are there CRLF in the file?

Please post the first 6 and the last 6 lines of the text file.

--Jeff Moden