ADO Connection String

by Linda Quinn

Close Window Print Page

OLE DB for Access (Microsoft Jet)

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" + _ "Data Source=c:\path\sample.mdb;" + _ "User Id=admin;" + _ "Password="

ODBC for Access

oConn.Open "Driver={Microsoft Access Driver (*.mdb));" + _ "Dbq=c:\path\sample.mdb;" + _ "Uid=admin;" + _ "Pwd="

OLE DB for Excel

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" + _ "Data Source=c:\path\sample.xls;" "Extended Properties=""Excel 8.0;HDR=Yes"""

ODBC for Excel

oConn.Open "Driver={Microsoft Excel Driver (*.xsl));" + _ "DBQ=c:\path\sample.xls;"

OLE DB for Text Files

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" + _ "Data Source=c:\path\sample.txt;" "Extended Properties=""text;HDR=Yes;FMT=Delimited"""

ODBC for Text Files

oConn.Open "Driver={Microsoft Text Driver (*.xsl));" + _ "DBQ=c:\path\;" + _ "Extensions=asc,csv,tab,txt"