Home Forums SQL Server 7,2000 T-SQL INSERT into Excel leaves values as text RE: INSERT into Excel leaves values as text

  • 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.