DataType Conversion

A

AsimKhaliq

Iam submitting some data from VB using ADO to Excel sheet.

like
rs.addnew
rs("sal")=formatcurrency(rss("sal"))

rs.update

every thing work fine but iin excel sheet in have text value for above
column(sal). Can any one help me How I can change data type so my excel
sheet have same datatype as in database

Thnx in Advance
 
Top