External link to an Excel Spreadsheet

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I get a "file doesn't exist" error when trying to
external link to an Excel spreadsheet in Access XP. I
believe this is due to it not recognizing a web address.

However if I place the file on the hard drive it links
okay but when trying to display via asp it says that path
needs to reside on the server.

Any ideas?
 
Hi Jim,

I'm not quite clear about your situation, but as far as I know Excel can
only link to files that are on local or network drives; it can't link
via Internet protocols and therefore not to a web address.
 
Thank you for responding.

Here is an example of what I am trying to do. If you
have an ideas I would be extremely grateful.

The access database is very large so I don't want to open
it to update it because it would take a long time. It is
on a web server because I am running asp pages off of it.

I get an excel spreadsheet each week with #'s for the
week for certain people. I created an asp page that
allows me to enter the week # and it runs through and
updates the #'s for the people in the results table.

This works fine if it is a regular access table that
holds the figures for the week. However since I don't
want to open the database I tried external linking the
spreadsheet. That is where I ran into the local/network
issue which you responded about below. So I moved the
spreadsheet to my desktop and the table externally links
and updates fine. However I can't run the asp page now
because the excel spreadsheet doesn't reside on the
server.

It is a Catch 22 - Any Ideas?
-----Original Message-----
Hi Jim,

I'm not quite clear about your situation, but as far as I know Excel can
only link to files that are on local or network drives; it can't link
via Internet protocols and therefore not to a web address.
I get a "file doesn't exist" error when trying to
external link to an Excel spreadsheet in Access XP. I
believe this is due to it not recognizing a web address.

However if I place the file on the hard drive it links
okay but when trying to display via asp it says that path
needs to reside on the server.

Any ideas?
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
If it's possible to edit the database by hand from your workstation via
ASP, an internet connection and a browser, it should also be possible to
edit it under program control with code running in Excel on your
workstation.

But that's about as far as I can go: if you know how to build ASP pages
at all you know more about web programming than I do<g>.


Thank you for responding.

Here is an example of what I am trying to do. If you
have an ideas I would be extremely grateful.

The access database is very large so I don't want to open
it to update it because it would take a long time. It is
on a web server because I am running asp pages off of it.

I get an excel spreadsheet each week with #'s for the
week for certain people. I created an asp page that
allows me to enter the week # and it runs through and
updates the #'s for the people in the results table.

This works fine if it is a regular access table that
holds the figures for the week. However since I don't
want to open the database I tried external linking the
spreadsheet. That is where I ran into the local/network
issue which you responded about below. So I moved the
spreadsheet to my desktop and the table externally links
and updates fine. However I can't run the asp page now
because the excel spreadsheet doesn't reside on the
server.

It is a Catch 22 - Any Ideas?
-----Original Message-----
Hi Jim,

I'm not quite clear about your situation, but as far as I know Excel can
only link to files that are on local or network drives; it can't link
via Internet protocols and therefore not to a web address.
I get a "file doesn't exist" error when trying to
external link to an Excel spreadsheet in Access XP. I
believe this is due to it not recognizing a web address.

However if I place the file on the hard drive it links
okay but when trying to display via asp it says that path
needs to reside on the server.

Any ideas?
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top