User needs to map a file path on a form

[montyb]

Greetings!

I have an Access database in which I am going to allow users to import data into a table from an Excel spreadsheet. The first question I have is how do I allow the user to "explore" to the proper path (in a text box or drop box)on a form so that user can locate the file they need to import? I could just have them manually input the path in a text box, but I would like to make it easier for the user by allowing them to map the path on a form.

I will then use that path in the code to find the proper file and import.

Thanks in advance.

 

[LonnieJohnson]

see FAQ faq181-152 ljprodev@yahoo.com
ProDev
MS Access Applications

 

[montyb]

I added the code and it allows me to browse, but how do find a file and then use the mapped address? I would like to have the address of the user's file show in a text box. Currently I have it set up where the user has to manually type the address in.

thanks