J
jobs
I have an excel spreedsheet that already has cells formated.
I'm trying to write data to excel from sql server (i've tried using
the jet 4.0 oledb driver and ssis's destination excel) however when I
write rows, it insist on loading data as text, so I get the excel cell
formating error tag on every cell. Any way around this?.
from another tool i've been able to work around this by writing this
to the top of the file, but that was for the web based version of
excel used by asp.net.
<style>.text { mso-number-format:\@; } </style>
the exact error is a green tag on every cell, help on it reads:
Convert numbers stored as text to numbers
I'm trying to write data to excel from sql server (i've tried using
the jet 4.0 oledb driver and ssis's destination excel) however when I
write rows, it insist on loading data as text, so I get the excel cell
formating error tag on every cell. Any way around this?.
from another tool i've been able to work around this by writing this
to the top of the file, but that was for the web based version of
excel used by asp.net.
<style>.text { mso-number-format:\@; } </style>
the exact error is a green tag on every cell, help on it reads:
Convert numbers stored as text to numbers