[RESOLVED] working with tab-delimited txt files
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!
Re: working with tab-delimited txt files
Use basic File I/O to read the file into an array, then split it on the tabs.
Re: working with tab-delimited txt files
umm.. can u post some codes on how to open it in that way.. :) thanx robdog
Re: working with tab-delimited txt files
VB Code:
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.