SQL query in excel vba RRS feed

  • Question

  • Hello, I need to do in excel one thing.

    I have an SQL view which is generating for me a table with almost 40 millions records. The clue is I need to see some of this records in excel. What I want to do is to have in excel, in one cell some kind of 'search cell' where I will put an ID and as a result I will have all information about this ID from my SQL view.

    With smaller table I could use Data>FromOtherSource>choosingSQLview>data in selected cell and filter data there - but like I said it's good option for small tables.

    That what I need probably must be coded in VBA right? - the problem is that I'm not to good with that so maybe you can help me and propose some solution and give some advice how to this

    Tuesday, December 1, 2015 2:25 PM