I need to read a column in excell which has more then 255 characters. The problem is that i can only read 255char max from one column, so i dont have the entire text from excell
I'm reading the file with the following code:
string excellConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Imports\Wachtlijst\17052010\wachtlijst.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
string excellQuery = "SELECT * FROM [WLOCMW$]";
OleDbConnection ExcelConnection = new System.Data.OleDb.OleDbConnection(excellConnectionString);
ExcelConnection.Open();
System.Data.OleDb.OleDbCommand ExcelCommand = new System.Data.OleDb.OleDbCommand(excellQuery, ExcelConnection);
int rowCount = 0;
OleDbDataReader ExcelReader = ExcelCommand.ExecuteReader();
while (ExcelReader.Read())
{
string opmerking = "";
if (!s ...
Go to the complete details ...