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

on Feb 09, 2017 06:17 AM

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

Download FREE API for Word, Excel and PDF in ASP.Net: Download
on Feb 09, 2017 06:58 AM
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'"/>