Browse button for user

[Dominic Trentadue]

Hello,

I was wondering how I could go about letting the user
choose the file to open for reading, instead of the
programmer.

My goal would be to create a diolog box that lets the
user browse for the file (txt or xls) on their own hard
drive, so I can then store that path into a variable and
import the data into a table. I think i could handle
the "open" and "read" part once I can get the path of the
file, just can't figure out how to launch the diolog box
that would return the path.

Please help,

Thanks
Dominic

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/api/api0001.htm at "The Access
Web"