Calling information from a Web Page

[alexi]

Gday,

This may sound like a strange request but it would be sensational if it could be done.

What i want to do is pull information from a web page and put it into the appropriate fields in my database.
The web page is java based and defines all the variables that i need to get info from.
What i want to know is can i write code in VBA behind a button or something that when i click on it it goes to the web page...then says eg.. me!ID = "www.webpage.com....variable ID" or something like that. i would imagine it to be more complex but thats the jist of it?

Any IDeas?

Cheers

 

[Travis]

Web pages don't normally contain Data, they are front ends to the data. XML documents are data storage pages that have schemas that can be used to read the data contained within. Without knowing the structure of the pages the only way you can strip data from a Web page (without having the access to where it gets its data) is to create a page stripping program (lots of complicated programming).

 

[alexi]

so there is now way of calling up a web page, downloading the code from the page, and then referenceing it to the database?
so u would put the code in a temp table or something?