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 –