access linked table to excel

Does anyone know a way to change the path of an access linked table so it will work on the web server?
For example I create a linked table to an excel file localy on my computer The path comes out to be c:\myexcelfile.xls. Access will not allow me to manualy type in the path and change it to my root folder on the web server. Is ther a work around to this?

 

Maybe create the link by first defining an ODBC datasource name for the Excel file? Treat it as a true datasource in its own right.

 

It looks like I can only create a odbc data source to an access db in discountasp.net. I cant create one that uses an excel file.

 

Search Google for "C# Excel OLEDB". You can use ADO.NET and access an Excel file. That's the best thing that comes to mind at the moment.