Windows 7 - Import Data from the Web to a SpreadSheet

Asked By rino80

21-Jan-10 09:20 PM

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)

I just want to import data from a regular web site onto my spreadsheet.  I have downloaded iodbc and no luck there...can anyone help...i have just switched over from a pc and have been using ms excel 07...all i had to do was to click data-from the web and just enter the webaddress...please help im going crazy with this...thanks in advanced...

22-Jan-10 12:09 PM

Excel for Mac is not equipped with the Web Query features provided in the
Windows versions. You have to write them as Text Files. This article gives
you the 'how-to' but it has not been updated for 2008 & I am not sure offhand
where they need to be saved in the 2008 version [no Macs available to me
right now];

http://support.microsoft.com/default.aspx?scid=kb;en-us;274787

--
HTH |:>)
Bob Jones
[MVP] Office:Mac

23-Jan-10 05:46 AM

Thanks CyberTaz for the quick reply...well i did follow the instructions and i got an error something to the effect that it couldnt obtain the info...anyone know on how to do this??  thanks in advanced...

23-Jan-10 08:06 AM

It seems to work fine here... The one difference being that the KB instructs
you to change the text file extension to .iqy, but I believe that is no
longer supported. Leave the .txt extension as is - but you may have figured
that out by now. I'd forgotten about that detail 8-}

Also, not all web sites are accessible by way of web queries. If you are
certain that the one you are trying to query should be usable perhaps there
is some sort of error in your text file. Exactly when does the error
display? You can paste a copy of the text file in a reply here if you would
like. Maybe I or someone else can spot what is preventing its success.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 1/23/10 5:46 AM, in article 59bb168c.1@webcrossing.JaKIaxP2ac0,

23-Jan-10 04:58 PM

CyberTaz, your a savior...well it did work, my mistake is that it doesnt work with rich text format...but it did work with .txt...i dont know why mac made it so hard to do this simple task...thanks again...