Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Import Data from HTTPS
Hello all
I would like to import data into an xl sheet from a new web query. I am trying to use the option Data - Import External Data - New Web Query. In the Address field of new window popped up, I pasted my website as " https://marketdataresearch.credit-su...commodities.do " and press Go. It is then asking Do you want to display the non secure items? I clicked Yes. Then the website appeared and I ticked (selected) the main table and press Import. At the end it says Unable to open https://marketdataresea........ Can not download the information you requested.. Any help please:-( Sri -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Import Data from HTTPS
FWIW, I see the same result.
It is probably not helpful to point out that you can select the content of the table on the website, Ctrl+C to copy it and then paste it into a worksheet, since you probably want to be able to refresh the query easily. I guess some websites are more amenable to querying than others, but it is not an area of expertise for me. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
Import Data from HTTPS
I tried opening your site directly. It presented me with a dialogue which I
had to answer, as to which country I was in. Perhaps when you use the site it does the same, and is still waiting for your answer? If so, you would need to provide the answer in your call to the site. -- music on the web: www.esnips.com/web/yahyas-music "Sri via OfficeKB.com" wrote: Hello all I would like to import data into an xl sheet from a new web query. I am trying to use the option Data - Import External Data - New Web Query. In the Address field of new window popped up, I pasted my website as " https://marketdataresearch.credit-su...commodities.do " and press Go. It is then asking Do you want to display the non secure items? I clicked Yes. Then the website appeared and I ticked (selected) the main table and press Import. At the end it says Unable to open https://marketdataresea........ Can not download the information you requested.. Any help please:-( Sri -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import external data, data includes Excel function | Excel Worksheet Functions | |||
Excel and HTTPS. | Excel Discussion (Misc queries) | |||
Unable to open webpage error during a web query to https site | Excel Discussion (Misc queries) | |||
how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions |