Posted by: alece April 6, 2015
dot net help
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);



Read Full Discussion Thread for this article