lpszConnect | 指向指定额外参数的字符串表达式的指针,用于向ODBC或可安装的ISAM驱动程序传递。 |
数据库类型 | 标识符 | 路径
使用Jet数据库引擎的数据库 | "[database];" | "drive:\\path\\filename.MDB"
| dBASE III | "dBASE III;" | "drive:\\path"
| dBASE IV | "dBASE IV;" | "drive:\\path"
| dBASE 5 | "dBASE 5.0;" | "drive:\\path"
| Paradox 3.x | "Paradox 3.x;" | "drive:\\path"
| Paradox 4.x | "Paradox 4.x;" | "drive:\\path"
| Paradox 5.x | "Paradox 5.x;" | "drive:\\path"
| Excel 3.0 | "Excel 3.0;" | "drive:\\path\\filename.XLS"
| Excel 4.0 | "Excel 4.0;" | "drive:\\path\\filename.XLS"
| Excel 5.0 or Excel 95 | "Excel 5.0;" | "drive:\\path\\filename.XLS"
| Excel 97 | "Excel 8.0;" | "drive:\\path\filename.XLS"
| HTML Import | "HTML Import;" | "drive:\\path\filename"
| HTML Export | "HTML Export;" | "drive:\\path"
| 文本 | "Text;" | "drive:\\path"
| ODBC | "ODBC; | DATABASE = database; UID = user; PWD = password; DSN = datasourcename; LOGINTIMEOUT = seconds;" (这可能不是适用所有服务器的完整连接字符串; 它只是一个例子。参数之间不要有空格这一点很重要) 无
| Exchange | "Exchange; | MAPILEVEL = folderpath; [TABLETYPE={ 0 | 1 };] [PROFILE=profile;] [PWD=password;] [DATABASE=database;]" "drive:\\path\\filename.MDB"
| |