Microsoft Query to pull external data?

There is much query with MS Query for me too.
The 'as name' expression does not work when I connect to
dbf-files. That's true.
As to Oracle, I know o good way to solve this in MS SQLServer.
You can use stored procedures and views.

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