hi ,
i need to load data into excel file from SQL table , but in excel file some of the fields should come as a numeric and not as a text.
for that i created a template with the appropriate data type, i am loading by copying template and after the first row(first row is a dummy data into file) and then i m removing data from the first row, which give me a blank line in excel.
now i am overwriting that blank line with values and which is working fine, the only problem is [DATE], i have some columns in table with [DATE] datatype, in template it is mm/dd/yyyy format and it copying correct, but when there is [DATE] value in NULL in table, its copying like '1/0/1900', i want to to make it blank in excel file.
how to do it?