Microsoft Query to pull external data?

I cannot answer your question about why the error appears, but I have found on some on my MS Query embedded links, that the error message doesn't appear if I don't name the columns within the query (the "as ..." part).

By taking this out, my queries have generally worked ok. If necessary, I just execute a macro to change the column headings on completion.

If anyone can suggest why this occurs, I would be interested.

Try as 'Year', as 'Month' and so on.

Thanks for the follow-up. I wound up getting more reliant on Views, something I hadn't previously used very often.

I will try the quotes technique though, thanks