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.
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.