Hi,
I am using SQL 2000 server DTS to export the data from
three views into a Excel 2003 file - each into a
worksheet inthe same workbook.
I am able to export the data into three sheets in the
same workbook. The only problem is that for all the
number cells, I got the a green error indicator at the
left upper corner. The error is because each number cell
is stored as text. In order for me the to do simple
calculation such as SUM or AVERAGE, I have to manually
convert the number cells from text into number.
In the SQL DTS package, I noticed that the destination
table is always created as the text (all columns are
varchar(255)). Even I could create the table the first
time using the database data structure (having
decimal ,int etc.) by clicking the "create" in the
transformation property. The first time, the right
format is saved into the excel sheet. After saving the
package, if you run the same package, it returns to the
all text format again. In the DTS package , the
tranformation property shows that the destination is all
text table.
Does anybody know how to set up the DTS package , so
that the excel sheet (not CSV) preserve the source data
format (number , not always turn into text)?

Thank you!

Carol