hi all,
i have scenario, i just want to read the data from excel file.. around 600 columns available...listed in alphabets...i dont have a problem to read first counts of datas(150 to 200 datas) but when am i trying to read remaining it throw me an error..this my
code
oledbConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + @"C:\Users\devmod1\Desktop\excel\ccg.xlsx" + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';");
oledbConn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT Materials," + mediumstr + " FROM [Sheet2$] ORDER BY " + mediumstr + " ASC",oledbConn);
OleDbDataAdapter oleda = new OleDbDataAdapter();
DataSet ds = new DataSet();
//cmd.Connection = oledbConn;
// cmd.CommandType = CommandType.Te ...
Go to the complete details ...