Get data from Web in Access

[Andro Dgebuadze]

Hi

Is there any way I can import data from the web to Access.
Excell has the tool Web query and I use for importing exchange rate from
website.
I need my exchange rates to be automatically updated from web, how should I
do it?

Andro

 

[Jacek Segit]

Witaj Andro,
W Twoim li¶cie datowanym 17 maja 2004 (10:35:29) mo¿na przeczytaæ:

AD> Hi
AD> Is there any way I can import data from the web to Access.
AD> Excell has the tool Web query and I use for importing exchange rate from
AD> website.
AD> I need my exchange rates to be automatically updated from web, how should I
AD> do it?

SQLAgent + DTC
What version of sqlserver you have? 2000, 7.0?
If 2000 then you can nice and quite easy import xml..

Regards
Jacek Segit

 

[Andro Dgebuadze]

Dear Jacek

Yes I have SQL Server 2000.
Coulc you please give me a hint how to bring web to xml first?

Djienkuen bardzo

Andro