Excel Database Connection String in C#

In this article, I have listed C# code snippets of connection string for Excel Database.


Excel Database Connection String in C#:

Connection String provide the required information to the driver that tells where to find the default connection information. Optionally, you are allowed to specify attribute=value pairs in the connection string to override the default values stored in the data source.

1. ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString = 
              "Dsn=DsnName;" + 
              "Uid=UserName;" + 
              "Pwd=Secret;"; 
conn.Open();

2. ODBC without DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString = 
       "Driver={Microsoft Excel Driver (*.xls)};" + 
       "Driverid=790;" + 
       "Dbq=C:\MyPath\SpreadSheet.xls;" + 
       "DefaultDir=C:\MyPath;"; 
conn.Open();

3. OleDb with MS Jet

using System.Data.OleDb;
var conn = new OleDbConnection();
conn.ConnectionString = 
    "Driver=Microsoft.Jet.OLEDB.4.0;" + 
    "Data Source=C:\MyPath\SpreadSheet.xls;" + 
   @"Extended Properties=""Excel 8.0;HDR=Yes"""; 
conn.Open();

– Article ends here –

If you have any questions, please feel free to share your questions or comments on the comment box below.

Share this:
We will be happy to hear your thoughts

      Leave a reply

      www.troubleshootyourself.com
      Logo