File I/O Using VBA As well as these functions, you may also find
that you will need to use some of the VBA string handling
functions, such as InStr, Left, Mid, Right and Trim, to parse
the data as required. There is an example of some of these
functions on this page being used to read data in from the
cdplayer.ini file. EOFThis function indicates when you have
reached the end of a file, and as such it is normally used as
the condition for a Do loop. Input #This function will read data
from a file that has been written to using the Write function.
As this means that text will normally be delimited with quotes
and similar, it is not of much use for general text importing.
InputThe Input function will import the number of specified
characters at a time into Access. This is probably of most use
when you have a record of fixed width (i.e. you have set the Len
argument of the Open statement). One trick with this function is
to read the whole file into Access in one go - this is often
faster than reading it line by