I wish to Import from an ODBC data source which has fields NAME and WORKING_TITLE. I want the fields to be Name and Title so I wrote a query to alias those fields and leave the rest unchanged.

But I get an error "Unable to read names from ODBC data source" in the wizard when I try to select the query as the "database table that contains the data".

The same error happens for every query, so does that mean that queries cannot be used as source tables?