My connection string looks like this for excel, so if the user with the services account exists in the server then it should be able to acces the file., i am confused on this.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\"Here i provide the path"';Extended Properties="EXCEL 12.0 XML;HDR=YES";