Excel cell link with System table cell using ODBC connection RRS feed

  • Question

  • using excel 2010, want to Link in Excel file item # cell with system table pulling data from for this item using ODBC connection, 

    I did created the report , and try connecting with excel file, when I connect with excel, its brings all the all the fields are created in the file, donot want all the fields, just want to pull the price for this item

    for example  if user enter in excel file   item # 10005660   would like  just Price to pull from this table not all the fields,

    I have 3 fields  in this report,  item # date , and price ,  can this be possible ? and can this be also done as range also

    can some one help me with this

    • Edited by Bitia Tuesday, February 18, 2014 7:22 PM donot know which forums to post this question
    Tuesday, February 18, 2014 5:09 PM

All replies

  • any update on this question,  unless my question is not clear,  looking for help to connect excel cell to sql data base table cell , 

    I have already created report in MS query ,    any help will be appreciated

    thanks in advance

    Wednesday, February 19, 2014 6:31 PM