MS SQL Server 2014 connecting to a remote server via VPN

[JC0133]

I am trying to use MS SQL(client) via VPN to convert a Excel sheet on the server to a table but I am having trouble figuring out how to do this.

Everything I have looked at online is showing me how to connect via VPN to a MS SQL Server. I believe I am trying to do the opposite.

Like I know how to convert a Excel sheet locally to a table but I need to do that remotely.