<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
Is anyone aware of any Excel import problems to SQL Server?<br />
<br />
Basically - I'm importing from Excel using SQL Server 2005 SSIS. &nbsp;<br />
Weve had problems where some values just dont get imported. &nbsp;<br />
<br />
For example, we have size columns (for example, womens sizes) which were set as text (weve tried number also) format importing to varchar(255). &nbsp;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. &nbsp;So we added a fullstop after the single values, for example 12 become 12. and this worked. &nbsp;Has anyone experienced this problem before?<br />
<br />
We now have a new related problem where other sizes (men's neck sizes) are not all getting imported. &nbsp;They are set to text format and importing to varchar(255). &nbsp;Adding a fullstop after the value makes no difference this time.<br />
<br />
Bit weird. Not sure what to do. Hope you can help?<br />

</div>
</div>


Hello

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?


Fields missed out when importing from Excel to SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.