[RESOLVED] working with tab-delimited txt files

[popodc]

Hello again, im trying to import an tab-delimited text file and id like to know on how to open it using vb 6? heres the scenario.. Once ive imported the txt file(tab-delimited), i will now generate a report using data report to display the results in the tab-delimited txt. thanks in advance!

[RobDog888]

Use basic File I/O to read the file into an array, then split it on the tabs.

[popodc]

umm.. can u post some codes on how to open it in that way.. thanx robdog

[RobDog888]

Dim strFile As String
Dim ar() As String
Open "C:\Test.txt" For Input As #1
    strFile = Input$(LOF(1), 1)
Close #1
ar = Split(strFile, vbTab)
 
'Generate your report using the ar array filled with one line of text per array element.