How to Set ConnectionString to use CSV Format File in ASP.Net

Last Reply one year ago By Indresh

Posted one year ago

I have two excel sheet Extension i want .CSV Connction Sting

Posted one year ago Modified on one year ago

 Hi rhino000,

Please use below code in your web config.

 <add name="Excel08ConString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='text;HDR=Yes;FMT=Delimited'"/>