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?
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.