Unanswered: Prompt for path/filename of linked spreadsheet
I have a table in my database gets updated with information from a spreadsheet. Currently, I have the spreadsheet linked as a table and whenever an update is needed, one of my users sends me the current spreadsheet, I save it over the old one and I run an update query.
I'd like to set it up so the user can run the query and be prompted for the location of the spreadsheet. The spreadsheet will always be the same format, but it would likely be in different places on each person's machine and different people would be doing to update at different times . . .