Automatic updating from website

[Jsnmeng]

Ya, i am new user of microsoft access from Malaysia. I would like to ask some
question from anyone in this forum. I am doing my report for my lecturer. He
want me to design a database by microsoft access. There are 3 part of it. I
have finished two part already. The uncompleted part is automatic update the
closing price (from stock market) of one manufacturing company into the
microsoft access. Could i know the Microsoft access can do the automatic
update the closing price from the this website
http://www.klse.com.my/website/bm/market_information/prices/index.jsp
into my database. Thank

 

[Wayne-I-M]

It would be very complex - shell call to source then insert via an append.

But - much simpler.

Ask the website to send you daily rate by e mail. Or most FX site can be
download to csv which is much simpler to bring into access.

There may be a method of parseing from htlm tabs but this will fail if the
website alter the tab link - and you have no control over this. Note if they
are using send or post asp, php, etc then this will not work anyway unless
you link to the receiveing page -

Best to just ask the website owner of they have a facility to do what you
want and if not then use another site that does