At present I use a Transfer Database Macro to import data into the database, it works perfectly if the file the user is importing from is in the correct position. But it is disasterous if the file has been moved. Is there a way the user can browse for the actual file. Using 2003 or 2007. My coding is nearly non-existant so I would rather build into a macro if possible. Any help would be appreciated.
Start Free Trial