web query in Access 2007

  • Thread starter Thread starter YAM
  • Start date Start date
Y

YAM

Hi

I need to state a query the gets information from the WEB as a parameter and
uses it in a calculate query.
specifically, I need to translate product prices from $ to EURO using
up-to-date currency rate.

Can a query do that automatically?

Thanks, Yaniv
 
If your application runs inside Access itself, you can call one of your own
made public VBA function (stored in a standard module, not in a class, not
under a form) in your query. This function may call the web-service you
need, say, returning the $/Euro actual rate, result that can be then used in
your query.

Vanderghast, Access MVP
 
Even if it is clearly possible to extract values from any web pages (you can
parse yourself the HTML code), I don't know of any simple mean to do it and
if I would have to do it, I would probably not use VB6/VBA to do it.


Sorry,
Vanderghast, Access MVP
 
thanks, Yaniv

Michel Walsh said:
Even if it is clearly possible to extract values from any web pages (you can
parse yourself the HTML code), I don't know of any simple mean to do it and
if I would have to do it, I would probably not use VB6/VBA to do it.


Sorry,
Vanderghast, Access MVP
Click to expand...
 
Back
Top