I need to import the contents of a large "space" delimited file into an access database.
The problem I have is some lines contain a comma and when they do the input # function splits them into seperate lines which messes up what I am doing.
Is there any other way of importing a text file line by line, that won't get messed up by a comma?
The process I am currently using is:
open test.txt For input as #1
Input #1, txtMyline
Do While Not EOF(1)
' Do my processing
Input #1, txtMyline
Loop
The problem I have is some lines contain a comma and when they do the input # function splits them into seperate lines which messes up what I am doing.
Is there any other way of importing a text file line by line, that won't get messed up by a comma?
The process I am currently using is:
open test.txt For input as #1
Input #1, txtMyline
Do While Not EOF(1)
' Do my processing
Input #1, txtMyline
Loop
