ADO Connection String Examples
by Linda Quinn
Close Window
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"
=================================================================
This content was created by Linda Quinn of LQNet.
See http://www.lqnet.com for a great
collection of articles on this and other topics.
=================================================================
Copyright © 2006-2008, LQ Systems,Inc. All rights reserved.
====================================================================
Want an expert to help with your project?
LQ Systems, Inc.
Business Solutions
====================================================================