can anybody help me to create formmated Excel file using SQL server 2005, I have one additional requirement as one column values that starts with 0000 but in excel it is not showing 0000, but if we can do that column values converted into Text using SQL server so that problem may be solve, and It should be formatted cell and once it is created then send to perticular forlder, using BCP or whatever.
Please advice.