Importing information to access from web page

[Greg]

Hi
I wish to import a street address from a web page. An example is
http://www.domain.com.au/Public/Prop...x?adid=3967440 ( In
this case the info I wish is below the yellow Rain and Horne logo,
ARNCLIFFE $240 18/8-12 KING EDWARD Street) currently, I am cutting and
pasting the info by hand into the database, as the address is formatted
on two lines on the web page, this is quite time consuming. The title
bar on the web page actualy has the info in the correct format for my
access database.
Is there any way of extracting this information with access without the
need to go thru the process of "view" "source" then copy paste.Or could
anyone steer me in the right direction for an answer.
Thanks
Greg

[miTch]

If you put a browser on a form that navigates to the page of you choice
you should be able to extract the data if it is in a form on the web page.

Look at this: http://files.bdmco.com/browser.mdb

"Greg" <gr********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi
I wish to import a street address from a web page. An example is
http://www.domain.com.au/Public/Prop...x?adid=3967440 ( In
this case the info I wish is below the yellow Rain and Horne logo,
ARNCLIFFE $240 18/8-12 KING EDWARD Street) currently, I am cutting and
pasting the info by hand into the database, as the address is formatted
on two lines on the web page, this is quite time consuming. The title
bar on the web page actualy has the info in the correct format for my
access database.
Is there any way of extracting this information with access without the
need to go thru the process of "view" "source" then copy paste.Or could
anyone steer me in the right direction for an answer.
Thanks
Greg

[pietlinden]

but I think the original poster wanted to do something like parse the
page. and grab the information inside a formatted section...

find this section:

<div class="propdetails-address">
<h1>ARNCLIFFE $240</h1>
<h2>18/8-12 KING EDWARD Street</h2>

</div>

and then remove the data. One way you *might* be able to do it is to
do something like:

1. get the position of the <div class="propdetails-address">
2. get the position of the next </div>

take everything in between (use InStr).
then parse out <div class="propdetails-address"> and the closing
</div>

then you're left with what you want. So you write it to your table.
How you do this on the fly straight from the webpage. Not a clue.