The tag has no usage guidance.

learn more… | top users | synonyms

16
votes
2answers
99k 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 ...
24
votes
15answers
22k views

Querying a CSV file

Does anyone know of a simple tool that will open up a CSV file and let you do basic, SQLesque queries on it? Like a graphical tool of sorts, one that is easy to use. I know I could write a small ...
1
vote
1answer
583 views

VB script or command line instruction to query a modem connected to my PC

Is there any vb script to query a modem that is connected to one of the ports of my machine?How can I query my modem from command prompt?
1
vote
1answer
3k views

Automating Access 2007 Queries (changing one criteria)

So, I have 6 queries and I want to run them all once at the end of each month. (I know a bit about SQL but they're simply built using Access's design view). So, in the next few days, perhaps I'll ...
0
votes
1answer
26 views

Outer join with union in Excel 2010 using Power Query

I've got two tables (two worksheets of the same workbook in Excel 2010): The result should look like this: My SQL code works well: SELECT table_2.ID, table_1.value_1, table_2.value_2 FROM ...
0
votes
2answers
148 views

SQL/DB browser for DB2

I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.