如何使用逗号分隔符使用ODBC读取文本文件 [英] How to read text file with comma delimiter Using ODBC

问题描述

尊敬的成员，

我正在使用以下代码将文本文件读取到datagridview中:

Dear members,

I am reading textfile into datagridview with following code

Dim Conn As System.Data.Odbc.OdbcConnection
Dim dt As New DataTable

Dim da As System.Data.Odbc.OdbcDataAdapter
Dim strConnstr, strImportFolder, strFilename, Filename As String

strImportFolder = "C:\"
strFilename = "abc" & "#txt"
strConnstr = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" & strImportFolder & "\;FMT=Delimited','"

Conn = New Odbc.OdbcConnection(strConnstr)

da = New Odbc.OdbcDataAdapter("Select * from[" + strFilename + "]", Conn)

da.Fill(dt)
MsgBox(dt.Rows(0).Item(0).ToString)

但我只把opuput当作整行使用(不省略，")
例如:

123，abc，xyz(仅一行)

但我只想要
123
abc
xyz


请帮帮我，

谢谢.

but i got opuput as whole line only(without omitting ",")
eg:

123,abc,xyz (Its only one line)

but i want only
123
abc
xyz


Please help me,

Thank you.

推荐答案

我没有发现您的代码有什么特别错误:这对我有用

I don''t see anything particularly wrong with your code: this works for me

Dim strConnect As String = "Driver={Microsoft Text Driver (*.txt;*.csv)};Dbq=D:\Temp\;Extensions=asc,csv,tab,txt;Persist Security Info=False;Fmt=Delimited"
Dim dt As New DataTable()
Using con As New OdbcConnection(strConnect.Trim())
	con.Open()
	Using obj_oledb_da As New OdbcDataAdapter("select * from [contactsShort.csv]", con)
		obj_oledb_da.Fill(dt)
	End Using
End Using
dataGridView1.DataSource = dt
MessageBox.Show(dt.Rows(1)(1).ToString())

您检查过数据文件了吗?第一行是什么样子?

Have you checked your data file? What does it''s first line look like?

这篇关于如何使用逗号分隔符使用ODBC读取文本文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！