PDA

View Full Version : only local SQL databases?



MartinBoers
06-23-2013, 11:39 AM
I had originally posted this in the Excel Help forum, where I thought it belonged, but there it was suggested that I post it here, so it here it is:

+++++++++++++++++++++++++++++++++++++++++++++++++++++

I know that Excel can access local SQL databases via VBA & PowerPivot, but can it also access online SQL databases?

austenr
06-23-2013, 03:44 PM
Maybe but you would need permissions.

Pogla
07-11-2013, 12:21 AM
I would assume it could connect remotely to a SQL database.

It is ODBC driven, isn't it???

Maybe???

The only gotcha that I can think of is what is known as the 'double hop'

If you are connecting to one remote server, and trying to authenticate to another remote server via the first one, you won't have the permissions to access the second remote server

Mdos568
03-16-2017, 10:18 AM
no idea