So you programmatically want to link a static excel file to an Access database...
Well, I'd suggest that you don't link the file, rather you import the data into a table that you create.
Then take a look at the following command in VBA:
The Access helpfile will give you the rest of the information you need on this command!
I did search the helpfile which says the following
The following example imports the data from the specified range of the Lotus spreadsheet Newemps.wk3 into the Microsoft Access Employees table. It uses the first row of the spreadsheet as field names.
DoCmd.TransferSpreadsheet acImport, 3, _
"Employees","C:\Lotus\Newemps.wk3", True, "A1:G12"
Problem is that as it says, I still have to specify a path. What is that, since the file is on the web server.
Secondly, one more thing; I need access to import it automatically (everytime the excel file is uploaded). What do I have to do?
Well, if you want it to happen everytime the file is uploaded, this doesn't sound like a Access problem, more of a web issue. How is Access supposed to detect a new version? It could periodically import the file on a timer event, but timer events in Access and websites do not mix well!
What language is your website programmed in? Sounds like we need to find a way of importing the spreadsheet to your db.