Excel Sheet Database Connectionstrings | Text File Database Connectionstrings | Microsoft Access Database

Excel Sheet Database

// ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Dsn=DsnName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open(); // ODBC without DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =        "Driver={Microsoft Excel Driver (*.xls)};" +        "Driverid=790;" +        "Dbq=C:\MyPath\SpreadSheet.xls;" +        "DefaultDir=C:\MyPath;"; conn.Open(); // OleDb with MS Jet using System.Data.OleDb; OleDbConnection 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();

Text File Database

// ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Dsn=DsnName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open(); // ODBC without DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =  "Driver={Microsoft Text Driver (*.txt; *.csv)};" +  "Dbq=C:\MyPath\;" +  "Extensions=asc,csv,tab,txt;"; conn.Open(); // Use: sql = "Select * From MyTextFile.txt" // OleDb with MS Jet using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =       "Driver=Microsoft.Jet.OLEDB.4.0;" +       "Data Source=C:\MyPath\;" +       "Extended Properties=" +         @"""text;HDR=Yes;FMT=Delimited"""; conn.Open(); // Use: sql = "Select * From MyTextFile.txt"

Microsoft Access Database

// ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = "Dsn=DsnName"; conn.Open(); // ODBC -- Standard Security using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =     "Driver={Microsoft Access Driver (*.mdb)};" +     "Dbq=c:\myPath\myDb.mdb;" +     "Uid=Admin;Pwd=;"; conn.Open(); // ODBC -- Workgroup (System Database) using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =     "Driver={Microsoft Access Driver (*.mdb)};" +     "Dbq=c:\myPath\myDb.mdb;" +     "SystemDb=c:\myPath\myDb.mdw;"; conn.Open(); Hide code // ODBC -- Exclusive Use using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =      "Driver={Microsoft Access Driver (*.mdb)};" +      "Dbq=c:\myPath\myDb.mdb;" +      "Exclusive=1;";      "Uid=Admin;Pwd=;"; conn.Open(); Hide code // OleDb with MS Jet -- Standard Security using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =            "Provider=Microsoft.Jet.OLEDB.4.0;" +            "Data Source=c:\mypath\myDb.mdb;" +            "User id=admin;" +            "Password="; conn.Open(); // OleDb with MS Jet -- Workgroup (System Database) using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =            "Provider=Microsoft.Jet.OLEDB.4.0;" +            "Data Source=c:\mypath\myDb.mdb;" +            "System Database=c:\mypath\myDb.mdw;"; conn.Open(); // OleDb with MS Jet -- With Password using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =            "Provider=Microsoft.Jet.OLEDB.4.0;" +            "Data Source=c:\mypath\myDb.mdb;" +            "Database Password=Secret;" conn.Open();