Importing data from live web page on startup

[Guest]

Or maybe it would be linking to the web site.

Here's the scenario.
Out server exports (appends) an index.sh (plain text) file (don't know why
sh) every so often.
I would like to make my access database automatically get the page when it
is opened. I have tried straight "Linking" the db to the page, but I keep
getting an error about the page read only, and then it tells me that the file
is in the wrong format. When I try linking as a text file, it tells me the
extension has to be txt, etc....
Is there, instead, a vbscript I should try writing instead - keep in mind
that I have very little programming experience... Any help would be greatly
appreciated.
Chris

 

[John Nurick]

Hi Chris,

These articles may help:

This http://support.microsoft.com/?id=304206 shows how to change the
extensions that Access will accept. The neatest method is the last,
editing the registry (provided you're careful<g>).

Alternatively, this http://support.microsoft.com/?id=306144 includes
code that automatically makes a copy of the textfile with a .txt
extension and imports that.

On Mon, 6 Sep 2004 19:55:02 -0700, "C. Clark" <C.

 

[John Nurick]

Hi Chris,

One way is to use an Autoexec macro; the other is to call code from the
Load event procedure of your startup form. (Look in Help for "Control
how an Access file looks and behaves when it opens" or some such)