I'm using Office 2010 and now I cannot edit existing query and Parameter both buttons are grayed out. Below are the steps I followed.
My requirement is to fetch the data from oracle database from Excel. by passing the three parameters.
2 and 3 are Date parameters.
steps followed to archive:
- setup-ed the ODBC connection in Control panel.
- Now back to Excel, open any excel workbook and select Data > From Other Sources > From Data Connection Wizard
- selected --> Other Advanced and then “Microsoft OLE DB Provider for Oracle”
- updated the connection string
- and Command text as
SELECT * FROM xx_salinfo a, xx_ivcinfo b
WHERE a.num = b.cd
AND a.status = NVL(Upper(''''||?||'''',a.status ) -- parameter1
AND so_wr_dt BETWEEN NVL(''''||?'||''', 01-JAN-05) AND NVL(''''||?||'''', 01-JAN-15) -- parameter2 and 3
But from here I have problem "Edit Query" and "Parameters.." both were grayed out. so im not able to pass/tag the cells values into the parameters.
please help me , how to fix it.
Note: This works fine without parameters. So, nothing wrong in steps.