如何从csv文件中读取完整的ip地址值 [英] How read full ip address value from csv file
问题描述
我需要一些帮助解决这个问题。
我有一个csv文件,只有一列是ip地址,我试图获取值,使用下面的例子ip地址就像这样< b> 192.168.201.42 ,但我有这样的ip地址值 192.1642
我是什么尝试过:
Dim strConnString As String =Provider = Microsoft.Jet.OLEDB.4.0; Data Source =&文件路径& ; Extended Properties = Text;
Dim conn As New OleDbConnection(strConnString)
尝试
conn .Open()
Dim cmd As New OleDbCommand(SELECT * FROM [& fileneme&],conn)
Dim da As New OleDbDataAdapter()
da.SelectCommand = cmd
Dim dt As New DataTable()
da.Fill(dt)
da.Dispose()
objConnection.Open()
抓住
最后
conn.Close()
结束尝试
我强烈推荐使用专用于rea的课程使用CSV文件而不是使用JET引擎,例如这篇文章中的拼写 [ ^ 一>]。
hi,
I need some help to solve this problem.
I have one csv file in that only one column is ip address,i tried to get the value use that below example ip address like this "192.168.201.42", but i got ip address value like this "192.1642"
What I have tried:
Dim strConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filepath & ";Extended Properties=Text;"
Dim conn As New OleDbConnection(strConnString)
Try
conn.Open()
Dim cmd As New OleDbCommand("SELECT *FROM [" & fileneme & "]", conn)
Dim da As New OleDbDataAdapter()
da.SelectCommand = cmd
Dim dt As New DataTable()
da.Fill(dt)
da.Dispose()
objConnection.Open()
Catch
Finally
conn.Close()
End Try
I would HIGHLY recommend using a class dedicated to reading CSV files instead of using the JET engine, such as spelled out in this article[^].
这篇关于如何从csv文件中读取完整的ip地址值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!