Tagged Questions

2
votes
1answer
816 views

Embed microsoft query in excel with multiple parameters from spreadsheet

I am trying to embed a microsoft query within an excel spreadsheet, that passes several parameters from the spreadsheet to the query. I would like the microsoft excel query function to find a few ...
1
vote
2answers
3k views

Pass a cell contents as a parameter to an excel query in Excel 2007

I have tried really hard to solve this issue but I think I am going to need a little help. I can program in different languages but I don't have any experience with Excel, VBA or the queries you can ...
8
votes
1answer
31k views

Run an SQL Query With a Parameter from Excel 2007

I have a query in an excel table. I followed this to do it. But how can I add a parameter from a cell into my query? I am looking for a way to do this select * from dbo.Customers where CustomerID ...
1
vote
2answers
886 views

Light-weight, free, database query tool for Windows?

My question is very similar to the one here except pertaining to a Windows tool. I am also referencing this table and what I found here with a Google search. However, I have no idea which tool would ...