ramachandranv
October 11th, 2004, 02:52 AM
Hi Guys,
Anybody out there who knows how to BCP into an xls file from SQL Server? I am able to do it to a text file but to an excel file any idea. I have created the destination with the necessary headings and ranges and then tried it but i am not getting the values into the range. it is putting each row in the first cell. any help would be appreciated.
Anybody out there who knows how to BCP into an xls file from SQL Server? I am able to do it to a text file but to an excel file any idea. I have created the destination with the necessary headings and ranges and then tried it but i am not getting the values into the range. it is putting each row in the first cell. any help would be appreciated.