Importing text file. Does entire file get read into memory first?

[sumdumgai]

Hello. I'm importing a rather large delimited text file into Excel. Here's a piece of code I'm using:

Open myPath & myFile For Input As #1
MsgBox myFile & " is open"
        
Application.StatusBar = "Reading records"

Do While Not EOF(1)
    Line Input #1, myStr       
    lineCount = lineCount + 1        
        If lineCount < 3 Then
            MsgBox myStr
        End If 

I immediately get the "is open' message, but it seems as though the 'mystr' message doesn't display until the entire 'myfile' is read into memory. Is that what is supposed to happen?

Thanks.

[InvisibleMan]

Sounds as though you only have one carriage return at the end of data.

https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx

Line Input # Statement

Reads a single line from an open sequential file and assigns it to a String variable.

Syntax
Line Input #filenumber, varname

The Line Input # statement syntax has these parts:

Part Description
filenumber Required. Any valid file number.
varname Required. Valid Variant or String variable name.

Remarks

Data read with Line Input # is usually written from a file with Print #.

The Line Input # statement reads from a file one character at a time until it encounters a carriage return (Chr(13)) or carriage returnlinefeed (Chr(13) + Chr(10)) sequence. Carriage returnlinefeed sequences are skipped rather than appended to the character string.

[sumdumgai]

Thanks, when I used Gsplit to break up the file, I specified 0x0A, which I believe is line feed. So, are you saying because there is no carriage return (0x0D), or no 0x0D0x0A sequence, at end of each line, the entire file is read into memory?

[InvisibleMan]

So, are you saying because there is no carriage return (0x0D), or no 0x0D0x0A sequence, at end of each line, the entire file is read into memory?

Pretty much, yes. At least, that's what the documentation seems to say.

Never used Gsplit, so I wouldn't know.