Hi,
I have posted this question in several forums a couple with no luck. I am hoping that someone here can help me out. I need assistance in developing a procedure that would allow an Excel spreadsheet to be chosen for import into a temporary Access table. As I mentioned before, all the references I have seen use a hard-coded or static path to point to the file while I need the ability to select different files from different locations (ie. Open/Save dialog box, etc.).
Thanks for your help!
Scott.
I have posted this question in several forums a couple with no luck. I am hoping that someone here can help me out. I need assistance in developing a procedure that would allow an Excel spreadsheet to be chosen for import into a temporary Access table. As I mentioned before, all the references I have seen use a hard-coded or static path to point to the file while I need the ability to select different files from different locations (ie. Open/Save dialog box, etc.).
Thanks for your help!
Scott.