Unanswered: Automating importing of txt files to a database
We need to setup a button that will automate the the importing of a text file into a set database, but we need to permit the user to choose which file to import as new files will be available weekly with different names. we would like to have some sort of Open/Browse/File selection to make it easy to change folders if needed. We are very new to OLE so we need the answer in simple terms. We need a solution that will work at all sites I have to deploy this application.