Home All Groups Group Topic Archive Search About

Importing data from web site

Author
17 Apr 2010 2:48 PM
Martin Parker
Hi

Is there any procedure with VB to mimic something like the 'get external
data from web' function within Excel.

I would like to import currency exchange rate data from a web site and show
the results in a listview control.

Any help on this would be very much appreciated.

TIA

Author
18 Apr 2010 6:52 PM
Nathan Sokalski
That depends on the website you want to import from. You can obviously read
the response sent from a URL, which could obviously be whatever the server
sends it as (html, plain text, graphic, file, or even just a series of
bits). If there is a URL that will return the data you want, or something
containing the data you want that you could parse, you can do that. Or, if
you have access to the same database or source that the website got their
stuff from, you could do that instead (that might not make it exactly "from
web", but it would be over the internet, and the web is nothing but a
specific part of the internet anyway). So it's not really a question of
whether VB.NET has any way to do it, but whether there is anywhere to get
the data from.
--
Nathan Sokalski
njsokal***@hotmail.com
http://www.nathansokalski.com/

Show quoteHide quote
"Martin Parker" <MartinPar***@discussions.microsoft.com> wrote in message
news:98C9D626-6B74-48C1-9A08-BA0701FA4A1E@microsoft.com...
> Hi
>
> Is there any procedure with VB to mimic something like the 'get external
> data from web' function within Excel.
>
> I would like to import currency exchange rate data from a web site and
> show
> the results in a listview control.
>
> Any help on this would be very much appreciated.
>
> TIA