Import problelm SQL to Excel

[timscronin]

I have a import file from perfmon that I dumped into Excel.
Several of the numbers look like this

0.00548763915799358

The field they are importing into on SQL Server is defined as float with a precision of 53. WHen they get imported in they look like 5.4876391579935799E-3. Shouldn't this data type hold this?

 

[TerryStover]

DTS seems to give the most generic data types when you load from excel. The numerics usually end up as float (which looks like your result) and the strings end up as nvarchar (double byte characters). You can override the default data types by clicking the transform box in the dts wizard when you create the destination table.