Is there any way to connect to a file located on Sharepoint Team Site?

[andre · Accepted solution]

If it's an Excel file, you should be able to consume it in both PP and PQ.  I am pretty sure it will also work with flat files, just use the URL of the file as the source

[mwaters4]

I cant find where to input a url for that to connect.  Im trying to connect to an access database file that is linked to a Team Site list (because you cant connect directly to a List in Sharepoint, which is absolutely asinine, btw.)

Can you tell me where this needs to be input in order to connect, please? 

thanks