Hi all,

I want to export some data from the SQL Server to Excel
worksheet using ADO and ASP.
I have already read the MS KB acticle and use the
recommend method to get data, open connection to excel and
then write the data to the worksheet using ADO in my ASP.
However, I find that after the program complete, the data
type of every column become TEXT, ie, have a preceding
single quote, even though the original data type is
Numeric.
The reason of the export function is allowing the user to
check the data in the database in a worksheet format, and
then import back the worksheet to the database if any
changes have been made. The advantage of this method is
many of the user find themselves more familiar with excel
worksheet rather than any file maintanence program.
However, when I export the data, all column become TEXT
but the user will input numeric data into certain column,
as a result, the import function (also using ADO) doesnot
recognize the mixed data coluumn and caused some data is
missing. It is hard to explain or forces the user to input
all column in TEXT format, even I do so, there is also a
risk that the user forgot to do so and casuse data loss.

Anyone have workaround this problem ?
Any help is highly appreciated

Thank in advance

Regards
ong