EXCEL import to sql returning NULL for decimals when in VARCHAR data type
Posted
by
Daniel
on Stack Overflow
See other posts from Stack Overflow
or by Daniel
Published on 2011-01-06T16:02:11Z
Indexed on
2011/01/06
22:53 UTC
Read the original article
Hit count: 187
Hi,
I am working on a peice of software which has expodentially grown over the last few years and the database needs to be regularly updated. Customers are providing us with data now on large spreadsheets which we format and will start importing into the database. I am using the Import and Export Data (32-bit) Wizard. One column in the database contains values like '1.1.1.2' etc and i am importing them in as a Varchar as that is the data type in the database. However, for values like '8.5', 'NULL' is getting imported insead. It only occurs when there is one decimal point.
Is this a formatting error with excel or is it the wrong datatype?
© Stack Overflow or respective owner