PDA

View Full Version : only local SQL databases?



MartinBoers
06-22-2013, 03:14 PM
I know that Excel can access local SQL databases via VBA & PowerPivot, but can it also access online SQL databases?

SamT
06-22-2013, 06:37 PM
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