Import Csv Files To Sql Server Problem

Hi,

I try to import csv files to Sql Server using .net. The code is as following:

string strCsvConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties='text;HDR=Yes;FMT=Delimited(,)';";

using (OleDbConnection cn = new OleDbConnection(strCsvConn))

{

string strSQL = "SELECT * FROM " + strFileName;

OleDbCommand cmd = new OleDbCommand(strSQL, cn);

cn.Open();using (OleDbDataReader dr = cmd.ExecuteReader())

{

// Bulk Copy to SQL Server

using (SqlBulkCopy bulkCopy = new SqlBulkCopy(strSqlConn))

{

bulkCopy.DestinationTableName = strSqlTable;

bulkCopy.WriteToServer(dr);

}

}

}
And the data is as following (simplified):
Model,Serial
AFICIO 3045,K9464900965
AFICIO 3045,K9464900932
Fax 5510L,A3761290041
Fax 2210L,A4978800008
AFICIO 3025,K8565201014
AFICIO 3025,K8565102398
The result of the 2nd column is: 9464900965, 9464900932, null, null, 8565201014, 8565102398 - either the first character is missing or the whole entry is missing.
One more weird thing is that some other files work fine, though I am not able to tell any difference between them.
Any idea is hoghly appreciated.
shz