ADO Connection String Examples
Printer Friendly 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"