I am trying to find out how to import an excel file that sits on a sharepoint library folder without needing to copy the file to my local machine first.

The address/location of the file is given in the following format:= http://sharepoint.com/dir1/excel.xlsx I retrieve this by using the "open in explorer" open on the sharepoint site.

When I use the import excel option in Access and enter this as the location for my file I receive the following message:

"only xml files can be imported from an internet"

I tried to do the same approach but with the UNC address:= \\sharepoint.com\dir1\excel.xlsx, but I get the same result.

Any guidance on how I might be able to achieve this would be greatly appreciated.