ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + openFileDialog2.FileName + ";Extended Properties=\"Text;HDR=yes;FMT=Delimited\"|";
SQLString = "Select * from ReportFile.txt";有一以“|”为分隔符的txt文档,想导入dataset,请问高手,用连接字符串方法可以吗?如果行,以上的连接字符串有什么问题?
SQLString = "Select * from ReportFile.txt";有一以“|”为分隔符的txt文档,想导入dataset,请问高手,用连接字符串方法可以吗?如果行,以上的连接字符串有什么问题?
txt还没有这么尝试过呢~~
oConn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=c:\somepath\;" & _
"Extensions=asc,csv,tab,txt;" & _
"Persist Security Info=False"
2、OLEDB
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited;"";"
"Data Source=c:\somepath\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited;"";"
好像不行,“|”放在哪里?