MS SQL Server 2014 connecting to a remote server via VPN

[JC724]

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.

 

[modi123]

Why wouldn't you FTP in and snag the file to do the work?

 

[bloodypulp]

What method are you using[trying] currently?
You can use SSIS, T-SQL, Linked Server, OLEDB, ODBC or RemoteDesktop directly to the server.