A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Import Data from HTTPS



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2008, 03:08 PM posted to microsoft.public.excel.links
Sri via OfficeKB.com
external usenet poster
 
Posts: 4
Default 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  
Old November 13th, 2008, 04:03 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default 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  
Old February 9th, 2009, 01:20 AM posted to microsoft.public.excel.links
Yoyo
external usenet poster
 
Posts: 7
Default 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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.