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

Friends,

 

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,

Rod

Outcomes