georgheretis (2/12/2016)

---

hi

i am import an Excel to a SQL Server ( using DB>TASKS>IMPORT DTA ...) and so on

i am creating an NEW table called 'aaa' from the Excel

the problem is that the data in one column in the original Excel has the following type

3461196008

3461196017

0100035.2

0100036.2

tha datatype of the specific column (table aaa) is float

the problem is when i am trying to see the data in SQL Server ( select * from aaa)

where tha data have the "0100035.2" is all of them null

i tried to change the datatype but the problem remaining , i cannot see the "0100035.2"

i will appreciate any help

thanks