AnsweredAssumed Answered

Using SQL Query Tables to get Descriptions

Question asked by Rodney Martin on Nov 17, 2017
Latest reply on Nov 5, 2018 by Rodney Martin



I have successfully logged into my SQL server from excel, and I have a list of the SW SQL tables.

Let me start with what I am trying to accomplish...


I want to be able to pull part parameter information into applications directly from the SW database.  For instance, via ODBE, I would like to type in a part number (one parameter) and the part description, and revision get pulled into the application automatically.  I want to do this first with excel.  Then, I am planning to develop API or use access as an intermediary, to do this data pull.  Any recommendations?


Thank you,