Home Forums SQL Server 7,2000 T-SQL INSERT into Excel leaves values as text RE: INSERT into Excel leaves values as text
bvdrsganesh
SSC Enthusiast
Points: 102
More actions
March 17, 2013 at 8:43 pm
#1597956
Andy RobertsonThanks for your quick solution to add blank cell. It worked well.
I added blank row with values 0.00 in Number columns as Hidden row. then it TSQL writes into excel in required number format instead of texts.