G
Guest
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!!!
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!!!