How to connect Excel DB using C# .Net

• Download XLSDB - 38 KB

Introduction

Get data from MS-Excel Using C# .Net

Using the code

string Con_Str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DB_Path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";";
                
        

in this DB_Path is the location of the .XLS file.

"HDR=Yes;" indicates that the first row contains columnnames, not data.

"HDR=No;" indicates the opposite.

"IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this option might affect excel sheet write access negative.

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)