webform xl upload, linked in access

[no bosh]

I am sort of seeing this may not be possible but maybe someone has an
idea.

A QuickBooks report gets massaged in XL and then uploads to a remote
server using asp. I am able to do an odbc connection and query that
table.

What I wish I could do is have the uploaded file act as a linked table
in access. Then I have an easier time doing joined tables and queries
in access.

Isn't there a way to manipulate the linked table path to something
else? I was thinking Server.MapPath would let me set the actual file
location on the remote server. If that were possible where would you
change this?

Is something like this possible? Or if not, could I import into the
access db when it is on a remote server since I can't use http or ftp.


Surely there is a way.

Scott

 

[no bosh]

If anyone is ever trying to do this...this worked.

Run an Asp page with server.MapPath to find out what the actual path
on your remote web server is.

ie. D:\website\bozocom\

then create a copy of your Excel file in a directory on your system
at D:\website\bozocom\linkedFile.xls

run the Link Manager and point to this file on your system.
Upload the database with this new linked file location.

The File won't be visible , at least in Macromedia MX when you create
a recordset but, you can create queries in the database Joining tables
or what have you and create a recordset from that View.
And if I could do it as a non-programmer....
you can too