Dubli Join Us

Search About New Technology and Bug

Wednesday, December 21, 2011

Ms Excel in C#,VB.Net Could not find installable ISAM

When you are going to use Ms Excel in c#, If you get this error when importing a excel file 

use this connection string 

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +Server.MapPath("Master.xlsx") + ";Extended Properties='Excel 12.0;HDR=YES;'" 

"HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite. 

1 comment: