CSV文件连接串

最新推荐文章于 2021-03-14 11:31:07 发布

地下室

最新推荐文章于 2021-03-14 11:31:07 发布

阅读量595

点赞数

文章标签： csv microsoft path

本文链接：https://blog.csdn.net/dixiashidixiashi/article/details/4003317

版权

”Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=“ + Path	     <br />

Path:的值为csv文件的上级目录。

访问实例：

            Dim objDataTable As DataTable = New DataTable()
            Dim objDataAdapter As OdbcDataAdapter
            Dim objCommand As OdbcCommand
            Dim objConnection As OdbcConnection

            objConnection = New OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" & Server.MapPath("."))
            objCommand = New OdbcCommand("SELECT * FROM " & strFileName, objConnection)
            objDataAdapter = New OdbcDataAdapter(objCommand)
            objDataAdapter.Fill(objDataTable)