Common Database Connection Strings
Access
Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\temp\sample.mdb
dBASE III
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=21
dBASE IV
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=277
dBASE 5.0
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=533
Excel 3.0/4.0
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp; DriverID=278
Excel 5.0/7.0
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp\sample.xls;DriverID=22
Excel 97
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp\sample.xls;DriverID=790
Oracle
Driver={Microsoft ODBC Driver for
Oracle};Server=OracleServer.world;Uid=demo;Pwd=demo
Paradox 3.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=26
Paradox 4.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=282
Paradox 5.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=538
SQL Server
Driver={SQL Server};Server=myserver;Database=pubs;Uid=sa;Pwd=
Text/CSV
Driver={Microsoft Text Driver (*.txt;*.csv)};DefaultDir=c:\temp