Posted by: alece April 6, 2015
Login in to Rate this Post:
0
?
why don't u try something like this?
string path = @"C:\Desktop\test.xlsx";
string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";
SqlCommand cmd = new SqlCommand("select * from[Sheet1$]",conStr);
string path = @"C:\Desktop\test.xlsx";
string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";
SqlCommand cmd = new SqlCommand("select * from[Sheet1$]",conStr);