AnsweredAssumed Answered

SQL Searches in excel

Question asked by Rodney Martin on Nov 29, 2017
Latest reply on Nov 30, 2017 by Jacob Corder

I am wanting to use the ODB import in Excel to pull the file state into excel based on an input of the parameter "PartNumber", or even the first 5 digits of the filename (which is also the part number).  I was hoping to be able to do this in the query builder in Excel, and not have to write some SQL script.  Possible?

 

BTW, I have been successful in getting into the SW SQL tables in excel, but I'm not sure I'm finding what I need to build the query. 

 

Thanks,

Rod

Outcomes