Transfer from Excel to SQL Server

[rawatds]

Hi all
I am importing a Excel file with DTS Packages in SQL Server. There is a column in which the value stored is -0.03. After i import this excel file in SQL server , the data -0.03 is changed to 2.99999 like this . The column in the database where i am putting value -0.03 is Varchar(20) .
I tried with changing the format of Excel sheet from General to Text but of no avail.

Please help me as this is very urgent and imp to me.

regards
rawat

 

[dbomrrsm]

I always find it easier to save the excel shwwt as a text or csv file then import that with DTS. Them results are much more what you expect doing it this way.

[blue]DBomrrsm[/blue]

 

[EdwinGene]

Is it practical for you to define your destination column as 'float' instead of 'varchar'?