Hello,
I would like to automate the process of importing an Excel spreadsgheet into a temporary Access 2000 table. I am familiar with how to do this using a macro and through code but the problem I am facing is that all of the code examples I have seen as well as the macro settings only allow for one file to be used through a hard-coded path. Is there any way of making the file selection dynamic or to have an "Explorer-like" window appear allowing selection of the necessary file?
Any assistance would be appreciated.
Thanks for your help!
Scott.
I would like to automate the process of importing an Excel spreadsgheet into a temporary Access 2000 table. I am familiar with how to do this using a macro and through code but the problem I am facing is that all of the code examples I have seen as well as the macro settings only allow for one file to be used through a hard-coded path. Is there any way of making the file selection dynamic or to have an "Explorer-like" window appear allowing selection of the necessary file?
Any assistance would be appreciated.
Thanks for your help!
Scott.