iccsi said:
I need to read a text file using VBA.
Any sample code to open, read, write and close a text file.
The specific code you would need depends on the nitty gritty
details of the content of the file and exactly what you want
to do with it.
In general, check VBA Help on the FreeFile, Input, Seek,
etc. functions and the Open, Close, Input #, Write #, Line
Input #, Put, Print #, etc. statements.
For a clean .csv kind of file, you may be able to avoid all
the complicated stuff and just link to it almost as if it
were a table in another database.