Importing to Excel by Web Query
921569Mar 3 2012 — edited Mar 3 2012I have searched many forums for an answer to my issue. I am working to have an Web Query setup from Oracle BI Answers to my Excel Source data for report presentation. When I have setup my Query and saved it I have set it to Bypass Oracle BI Presentation Services Cache. This then gives me the option to download a Web Query (*.iqy file). When I connect that to my workbook in Excel 2007, I get an error "Cannot locate Internet Server or proxy server." And it never prompts me for my Username and Password as everything has indicated it should.
Please help me. If there is another simple way to have a automatic refreshing Query setup to import into excel, I would also appreciate that info.
Thank you.
-Carl
Edited by: 918566 on Mar 3, 2012 1:12 PM