Fields missed out when importing from Excel to SQL Server
Posted on 2007-10-21
Is anyone aware of any Excel import problems to SQL Server?
Basically - I'm importing from Excel using SQL Server 2005 SSIS.
Weve had problems where some values just dont get imported.
For example, we have size columns (for example, womens sizes) which were set as text (weve tried number also) format importing to varchar(255). If the size included a hypen (such as 10-12) then it imported but if the size was a single value, such as 12, it didnt import. So we added a fullstop after the single values, for example 12 become 12. and this worked. Has anyone experienced this problem before?
We now have a new related problem where other sizes (men's neck sizes) are not all getting imported. They are set to text format and importing to varchar(255). Adding a fullstop after the value makes no difference this time.
Bit weird. Not sure what to do. Hope you can help?