question on speed

[sal21]

I use the tipical free file ... eof eccc... to read line by line a txt file.
i need an explain.

instead to use the code to read the txt in a server dir, i have a good performance if i copy in local c:\ the txt and read it?

or have the same performance in order of time?

[HansV]

Generally speaking, reading from your hard disk will be a lot faster than reading from a network drive.
With a small file, you won't notice the difference, but if you're working with a really large file, you'll see better performance if you first copy the file to your hard disk, then read it using VB/VBA.