I came across an Excel file that is sourcing data from an outside server. I'd like to understand how the connection string works so I can recreate it elsewhere.
The connection string is in following format:
The connection string seems to be enough to establish the connection with the server; however, after playing with a number of different options in Excel, I'm unable to establish a connection.
My question is, based on this connection string, what "source" type do I need to use in Excel, to make this work?
Additionally, the "NA" parameter--this looks like a server IP, is that what it "NA" is? based on the information from this website, this does not seem to be a common parameter.