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

Last Reply on Feb 09, 2017 06:58 AM By Indresh

Posted on Feb 09, 2017 06:17 AM

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

You are viewing reply posted by: Indresh on Feb 09, 2017 06:58 AM.
Posted on Feb 09, 2017 06:58 AM Modified on on Feb 09, 2017 06:58 AM

 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'"/>