Is it possible to import Excel 2.1 worksheet to asp.net application. For this I used the connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=filename;Extended Properties='Excel 8.0;HDR=Yes;'". But it is showing format is not supported. Our client
using this format only, so I cant change the format through MIME type. Thanks in advance.
pavan.ck
Member
5 Points
11 Posts
Import Excel 2.1 worksheet in to asp.net application
Dec 13, 2012 05:26 AM|LINK
Hi All,
Is it possible to import Excel 2.1 worksheet to asp.net application. For this I used the connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=filename;Extended Properties='Excel 8.0;HDR=Yes;'". But it is showing format is not supported. Our client using this format only, so I cant change the format through MIME type. Thanks in advance.