I am populating an Excel data table from an Oracle db over an ODBC
connection. I would like to change the field names via the SQL in Microsoft
Query. All of the following return errors:
SELECT AP_INV_JE_LINE_DETAILS."ACCT$COMPANY" AS COMPANY

SELECT AP_INV_JE_LINE_DETAILS."ACCT$COMPANY" AS "COMPANY"

SELECT AP_INV_JE_LINE_DETAILS."ACCT$COMPANY" AS 'COMPANY'

ERROR: ORA-00923: FROM Keyword not found where expected
Any suggestions??? Thanks in advance!!!