excel sql query

  1. G

    Use a Column as Excel SQL Paramter

    Hi, Is it possible to use multiple values in a column as parameters for an Excel SQL query? This is my current SQL statement, but when I try to enter the column as the parameter, it does not accept it. SELECT Stock_Header.Part_Number, Stock_Header.Description...
  2. R

    Cell Reference parameters used in Excel SQL Queries

    Hi, I am extracting data from an SQL database into Excel 2007 using MS Query. I've used the following SQL code to prompt for the parameter: "WHERE casosdeuda.ConceptoDeuda LIKE (3) and a.`TipoCaso` in (?,?) and a.`TipoDeuda` in (?,?)" Using...

Some videos you may like

This Week's Hot Topics