G
great stuff
I am trying to import a textfile using oledbconnection.
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
MyConnection = New System.Data.OleDb.OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & connectionString &
";Extended Properties='text;HDR=No;FMT=TabDelimited'")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [" &
fileName & "]", MyConnection)
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet, "TextFile")
DataGridView1.DataSource = DtSet
but the values get formatted in this case
if i have the text file as below:
01
02
03
04
i get as below:
1
2
3
4
Without formatting how can this be done..
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
MyConnection = New System.Data.OleDb.OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & connectionString &
";Extended Properties='text;HDR=No;FMT=TabDelimited'")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [" &
fileName & "]", MyConnection)
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet, "TextFile")
DataGridView1.DataSource = DtSet
but the values get formatted in this case
if i have the text file as below:
01
02
03
04
i get as below:
1
2
3
4
Without formatting how can this be done..