This will only rename the files and not convert the CSV to XLS binary file.The question still remains why would you do it in SQL?I think it would work with SSIS. To read the CSV files in and then spit out as Excel.There are converters out in the net, just have to search for it.

I tried with SSIS it didnt work. The data are separated with double and single codes, while loading from CSV table its not getting the data in right format.However, when u load you convert to .xls and load to sql server table it works perfect.

Admingod (1/24/2013)I tried with SSIS it didnt work. The data are separated with double and single codes, while loading from CSV table its not getting the data in right format.However, when u load you convert to .xls and load to sql server table it works perfect.

Thanks

SSIS should work. Can you explain a bit more about "data are separated with double and single codes"?