Importing Data from Web link...

S

Suttd

Hi all,

I was hoping one of you may be able to assist me, First off I am using MS
Access2000: I need to import a web link into access but have had no luck so
far is it possible?

Thanks

Dave
 
S

Suttd via AccessMonster.com

Suttd said:
Hi all,

I was hoping one of you may be able to assist me, First off I am using MS
Access2000: I need to import a web link into access but have had no luck so
far is it possible?

Thanks

Dave
Click to expand...


Any idea's ?
 
S

Somer

Also trying to link or import data from http (port 80) I have als
request for a ftp (port 21). as there is no ftp or no anonymous ft
accout I got internal internet failure and no valic account errors. I
it possible to link/import from a http only?

You can try it by yourself: http://parex.scada.lv/popup/csv/graph5.cs
 
J

John Nurick

As far as I know, Access can't connect via http or ftp. If the file is
on your intranet you may be able to use a UNC path (e.g.
\\SERVERNAME\SHARE\folder\file.mdb); otherwise it needs to be dowloaded
to a local or LAN drive.
 
S

Somer

Access can conncet and link via Internet look at balloon help in lin
dialog --
File name or Web address (http://). The problem is exactly in both HTT
and FTP communications. Excel instead of Access go only to HTTP an
linking to http://parex.scada.lv/popup/csv/graph5.csv is successful
One idea is to link in excel and then make second link from access t
excel does work. But no automatik refresh on Linked table opening
First I must to open excel sheet and do automatic refresh, the clos
the sheet and open linked table. Maybe there is a way to automati
refresh excel sheet from access vba code
 
J

John Nurick

Access can conncet and link via Internet look at balloon help in link
dialog --
File name or Web address (http://)
Click to expand...

That's what it says, but I don't know anyone who has made it work in
real life.
 
Top