Opening text file with Visual Basic

[deeperlook]

I would like to use Access' Visual Basic to open a text file an
process it character by character, not to read it into a table, bu
for other purposes. I would also like to have a file selection box t
select the text file. How can I do this? I have Access 2003.

Thanks
Mart

 

[Allen Browne]

See the Open statement in the VBA help.

For selecting a file, see:
http://www.mvps.org/access/api/api0001.htm