I am trying to import a tab delimited file with ADO. If I convert my tabs to csv it works, but I would like to know why it does not work with tab.
TheFunction is on the buttom
here is my test data:

Test1:
- Create a Text file with Headers: Test1, Test2, Test3
and rows:
row1: 1,2,3; row2: 4,5,6; row3: 7,8,9

I create the file in Excel and export it from excel, if I read it back in as a delimited file it recognizes the tabs and displays it correctly.

here is the test file in hex:
54 65 73 74 31 09 54 65-73 74 32 09 54 65 73 74 |Test1.Test2.Test|"
33 0D 0A 31 09 32 09 33-0D 0A 34 09 35 09 36 0D |3..1.2.3..4.5.6.|"
0A 37 09 38 09 39 |.7.8.9 |"


I followed link:
http://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/9ac36a61-8556-4b50-861e-11db2d36b1d1/
but it does not help me

My output in my datagrid is:
Test1_Test2_Test3 for the header
1|2|3, the | is really a square box which indicates the Tab I suppose.
4|5|6
7|8|9
I binged and googled and yahooed and now I am ready to do a snore..

I hopeyou guys can help me

====

Function ImportTab(ByVal StrFileName As String) As Boolean

Dim StrSql As String = ""
Dim strCSVConnStr = ""
Dim myString As String = ""
Dim strfile As String = ""

ImportTab = False
Try

strfile = StrFileName

Dim myConnection As New System.Data.OleDb.OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\AlarmData;" & _
"Extended Properties='text;FMT=TabDelimited;HDR=YES'")

myConnection.Open()

StrSql = "Select * From [TabData.txt] ;"

Dim oleAdapter1 As New OleDb.OleDbDataAdapter(StrSql, myConnection)

Dim dtbCSV As New DataTable
oleAdapter1.Fill(dtbCSV)
DataGridView1.DataSource = dtbCSV
DataGridView1.Focus()
ImportTab = True

Catch ex As System.InvalidOperationException
Debug.Write(ex.Message)
ImportTab = False
End Try

End Function

###################