Hi all.
Iam trying to read data from .txt table delemeted with ", " and insert it into DataTable object. A problem is that only first 255 fildes pass to DataTable. Please somebody tell my why?
Here is the code:
string connectionString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + directoryName;
string SQL = "SELECT * FROM " + fileName;
// Create connection object
OdbcConnection conn = new OdbcConnection(connectionString);
// Open connection
conn.Open();
OdbcDataAdapter da = new OdbcDataAdapter(SQL, conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];