View Complete Post
Hi there,
I am trying to simply extract an excel data from an uploaded file an put it into a datatable. In this case the excel file has 3 rows but when I fill the datatable I only see row count of 2.
I tried changing HDR:NO; to HDR:YES and vice versa, but no luck.
What am I doing wrong? (Note: the excel file cannot have a headerrow)
string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pFilePath + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR:NO;\""; OleDbConnection conn = new OleDbConnection(connstr); conn.Open(); DataTable dtTables = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null); string strTablename = dtTables.Rows[0]["TABLE_NAME"].ToString(); string strSQL = "SELECT * FROM [" + strTablename + "]"; OleDbCommand cmd = new OleDbCommand(strSQL, conn); DataTable dt = new DataTable(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(dt); //At this point row count=2 which doesn't make sense
Hi,
I downloaded some project from some site which is made in VS 2003. When I open its project file in Notepad I get following at first line Microsoft Visual Studio Solution File, Format Version 8.00. I don't have VS 2003 in my PC but I have VB 2005 and 2008 Express Edition. Now I wanted to upgrade that file but it is not doing. Can somebody help to upgrade it.
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend