Am importing CSV and Excel data using the built in ASPRunne import tool
The tool works well for most columns bar 2.
Two of the columns have a mix of single digit charactes - some numeric and some alpha.
Have found that based on the first few values, the import tool appears to then exclude some of the data. If the first few rows have a numeric value in the column then any rows containing an alpha will have a null in that column once loaded. Similarly if the first few row have a char in that column then any numeric values will be ignored.
This is happening for a column which is char(1) and a column which is varchar(50)