toast691 Posted December 2, 2016 Share Posted December 2, 2016 Hi, I am trying to link my SQL Database to Microsoft Excel. Excel already has the function to do this link but it asks for the "Server Name". Where can this be located and is there any tricks to creating this link between the online database and Excel? Cheers! Stami Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 2, 2016 Share Posted December 2, 2016 I'm still using Excel 2003. So, how any other version of Excel makes a connection to a database server, I don't know. I would think the "Server Name" would be what CubeCart calls the "Database Host". That could be the network's "friendly" name of the server, such as "BadWolfBox" or "Aisle3Rack4Shelf6". Or, if the server is on the same computer as is Excel, then maybe "localhost". Or the actual IP Address or domain name. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.