Dear all,

some times i need to save result set of sql server in .csv format and then need to save in xls format with out loosing any

precision , i have some decimal values and some bigint values,

2003 ms offices gives option to set each columns type while

opening any .csv file , is it the only way i can preserve the type or is there any other easy was because some times number of cols are more.

yours sincerely