请问在ADO中能够直接连接文本文档数据库吗？

[sandrowjw]

就是Driver={Microsoft Text Driver (*.txt;*.cvs)}，这个格式的连接字符串，用ADO连接，现在总是提示我“没有输入驱动程序类型或者数据源”。
请问ADO是否支持这种格式的连接，如果支持的话我应该怎么做。

[sandrowjw]

有趣啊，把Driver改成DRIVER就好了。

[spwnihao]

我来接分

[spwnihao]

hoho~~

[sandrowjw]

也好，就散分吧，不过分是不多

[sandrowjw]

搞明白是怎么回事了，这个字符串挺严格的
Driver={Microsoft Text Driver (*.txt; *.cvs)}，我写成了
Driver={Microsoft Text Driver (*.txt;*.cvs)}，结果就不行了

[cdwy411]

哈哈！
就是么？

[AkiraChing]

ODBC Driver for Text

strConnection = _T("Driver={Microsoft Text Driver (*.txt; *.csv)};"
"Dbq=C:\\DatabasePath\\;Extensions=asc,csv,tab,txt;");

If you are using tab delimited files, you must to create the schema.ini file, and you must to inform the Format=TabDelimited option in your connection string

Note: You must to specify the filename in the sql statement....
For Example:

CString strQuery = _T("Select Name, Address From Clients.csv");



Connecting to a Text File using the JET OLE DB Provider: strConnect = _T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DatabasePath\\;"
"Extended Properties=\"\"text;"
"HDR=Yes;FMT=Delimited;\"\";");

Note: You must to specify the filename in the sql statement....
For Example:

CString strQuery = _T("Select Name, Address From Clients.txt");

see
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q262537

[MicoInNet]

mark