From asp application we upload an dynamic excel to the server from where the data from Excel is getting inserted into Database. But when the 1st row of teh excel is a number the remaining values in the same column are treated as number. So if there are any value in % comes that is converted into a decimal number & getting stored in Database.
Example

In Excel
2005
10%
20%

In database
2005
0.1
0.2

But we would like to save it in database as the % values.

we are using loader.asp which uses the fso, binaryData type of upload.

Please someone help.

Thanks


Prem Anandh P.
Ambition Never comes to an End

__________________
Prem Anandh P.
Ambition Never comes to an End

What method are you using to move the data over? All in the ASP? Stored Proc? DTS?

Hasta Luego..
KingRoon

DogFightClothing. No dogs. No fighting.

http://www.dogfightclothing.com

I'm using an all in ASP method i.e. a code written using file system object. I downloaded this code from some resource.

Prem Anandh P.
Ambition Never comes to an End

If I were you, I'd use DTS to sort your Excel data out.. It allows total data type control and is always a useful area to learn about..

There's a good article here http://www.sqlteam.com/item.asp?ItemID=19595

This will pretty much do what you are after..

Hasta Luego..
KingRoon

DogFightClothing. No dogs. No fighting.
http://www.dogfightclothing.com