Connect the Excel Database from C# .Net

• Download XLSDB - 38 KB

Introduction

It is the simple program. it explains how to connect MS-Excel Database.

Background

Creating Table in Excel is very simple and easy. also fetch from Excel table is also very easy.

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\";";

Here 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.