not able to read excel through oledb

Question

Hi

I was able to read the excel with oledbconnection and was getting in a datatable form.

But when I am trying to use a excel which is downloaded from web application from gridview then its not able to read it, throwing error "External table is not in the expected format."

Please help me on this as I am stuck here,not able to move further.

 

Regards

Rohan