<div>
I used your idea and built on it. &nbsp;If I did what you said to do it still would skip one once in a while with letters in it. &nbsp;So I just did two imports one with only the cells that had numbers only and the other with cells that had both. And it worked find...<br />
<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
I am trying to import into SQL server using the wizard an excel file. &nbsp;both columns have mixed numbers and letters. &nbsp;The first column imports correctly but the second column imports only cells with only numbers. &nbsp;What am I doing wrong?
</div>
</div>


I am trying to import into SQL server using the wizard an excel file.  both columns have mixed numbers and letters.  The first column imports correctly but the second column imports only cells with only numbers.  What am I doing wrong?

Import from excel

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.