HI,
I am doing bulk excel upload function. When i upload the excel data i get this error even though i changed the OLDB connection string
connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strUploadFileName + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";
or
connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strUploadFileName + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
or
connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strUploadFileName + ";Extended Properties=Excel 12.0 Xml;";
I used all this option already but no use. kindly pls support me.
This is my code:
if (strExtension.Equals(".xls"))
{
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data ...
Go to the complete details ...