Import Data from the Web to a SpreadSheet

[rino808]

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...

 

[CyberTaz]

Excel for Mac isn't 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 hasn't been updated for 2008 & I'm 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

 

[rino808]

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...

 

[CyberTaz]

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're
certain that the one you're 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'd
like. Maybe I or someone else can spot what's preventing its success.

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

 

[rino808]

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...