| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Field Name
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!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a text field to a date field | New Users to Excel | |||
| How to keep leading zero without changing field to text field? | Excel Discussion (Misc queries) | |||
| Changing Pivot Table Field Name | Excel Programming | |||
| Auto changing field trouble | Excel Programming | |||
| Problem changing pivot field | Excel Programming | |||
Threaded Mode
