How to fetch Data from Oracle Database to Microsoft Excel

How to fetch Data from Oracle Database to Microsoft Excel

Recently my Team Lead gave me the task to fetching the data from Oracle Database in Microsoft Excel through Microsoft Query. After spending some time in R&D I was successfully completed this task and now I am sharing my knowledge and steps to fetch data from Oracle Database to Microsoft Excel.

1) From the Data tab in MS Excel, click From Other Source icon

How to Fix Database Column Alias name problem in Microsoft Excel

How to Fix Database Column Alias name problem in Microsoft Excel

Database Column Alias name caused the query to fail problem when try to Microsoft Query to return data from some third-party database into Microsoft Excel. The error message that you receive depends on the data source that you use. I am using Oracle Database 10g and because the use of column alias name Microsoft Query generate ‘ORA-00923: FROM keyword not found where expected’ error.