only local SQL databases?

[MartinBoers]

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

[SamT]

Depending on the Libraries you have referenced, XL can query any database anywhere.

I'm not a DB man, so I don't know much more than that.

You ought to check out our DB forum;

http://www.vbaexpress.com/forum/forumdisplay.php?f=94