Thread: Mac Web Query
View Single Post
  #5  
Old November 13th, 2007, 10:11 AM
erichazann erichazann is offline
Registered User
 
Join Date: Nov 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
erichazann is on a distinguished road
Edit the .iqy file directly and where it says "Selection=EntirePage" change that to the table number(s), comma separated. To find the table number, view the source of the HTML page and search for <table (opening table tag) and count how many until you get to the table you want.

ex.
WEB
1
http://kitco.com/market/

Selection=20,23
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

This takes two tables from the url. The NY Spot Price table, and the World Market Spot Price table. Change formatting to All if you want the HTML formatting preserved.
Reply With Quote