I have a large file of text to input into a mdb data file.
The following function opens a text file, and is supposed to extract an entire line of text
URGENT : Parsing of a file of info to be imported in to an access data base.
' ok here is where the work is done
' get our file str
strfile = ff.Text
Open strfile For Input As #1
While Not (EOF(1))
Input #1, sLine
sLine = Replace(sLine, Chr(44), "~")
'parse data and save in Access .mdb
txtImport.Text = txtImport.Text & vbCrLf & "++++++++++++++++" & vbCrLf & sLine & vbCrLf
The text to be extraxted in one line is
Finemore, Stewart Andrew|1/20050722160450/972|286 Tracey Street||Lavington|NSW|2641|0260490558|0260409558|0400158520|275.00|22-07-2005|22-04-2006||Monthly||||||||||34587.97|590.30|04-06-1970|"
the problems arise in that the function treats the "," as the EOL - so only p[art of the string is extracted ...
Any idea ?