CSV到DATATABLE VB.net
时间: 2023-08-15 13:05:28 浏览: 78
你可以使用 VB.net 中的 OledbDataAdapter 和 DataSet 类来将 CSV 数据转换为 DataTable。以下是示例代码:
```vb.net
Dim filePath As String = "C:\test.csv"
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Path.GetDirectoryName(filePath) & ";Extended Properties='text;HDR=Yes;FMT=Delimited(,)';"
Using conn As New OleDbConnection(connString)
conn.Open()
Dim cmd As New OleDbCommand("SELECT * FROM [" & Path.GetFileName(filePath) & "]", conn)
Dim adapter As New OleDbDataAdapter(cmd)
Dim dataSet As New DataSet()
adapter.Fill(dataSet)
Dim dataTable As DataTable = dataSet.Tables(0)
End Using
```
这段代码将打开名为 "test.csv" 的文件,并将其转换为 DataTable。你需要将 `filePath` 变量更改为实际的 CSV 文件路径。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)