Doh!, never noticed, but it was on my phone, so you never get to see the full urllink has been copied twice - try https://access-excel.tips/add-auto-n...-access-query/
Thank you Ajax.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
there are plenty of alternatives, bit concerned the author doesn't seem to really understand how it works.
here's another one on the same principle
https://stackoverflow.com/questions/...lect-statement
more examples
https://accessexperts.com/blog/2015/...ing-in-access/