hi to all vb6 and vb.net expert!
i need help. i want to split the data from a text file and save it to the sql database.
attached here is the .txt file and the format.this data is from a chronolog machine im thinking of using string token but it does not have a separator.how can i split the strings. thanks any suggestions and comments will do.. this is the code that i've started. i've extracted the .txt file but i have no idea yet how to split it.
Set con = New ADODB.Connection
Set rec = New ADODB.Recordset
rec.Open "Select * FROM DT102T01.txt ", con, 3, 3
Set DataGrid.DataSource = rec 'display only to show that i get the data