change query path
 

I have a ton of querys in excel that pull data from an access db. I have to
change the location of the db and thus, have to change the path of the excel
querys. does anyone know of a quick way to dothis? thanks!