jobs
3/27/2007 8:00:00 AM
I have an excel spreedsheet that already got cells formated.
I'm trying to write data to excel (i've tried using the jet 4.0 oledb
driver and ssis's destination excel) currently using SSIS data flow,
but suspect this is a universal problem with 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 asp.net, i'm able to get around the issue by writing this out to
the to of the top file:
<style>.text { mso-number-format:\@; } </style>
But that might just because that's the html version of the browser,
but none the less does have the desired effect.