Hi,

I have setup an Access database which holds tables of information I need to
present in Excel. I have setup an 'Import External Data' Access Query, which
works fine and pulls through fresh data when I refresh the query, however I
moved the source file to another location and it can't find it.

Is there a way I can change this, I have 12 worksheets linking to different
tables in this database and am slightly reluctant to set them up again if I
don't need to.

Thanks for any help...