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