The tag has no wiki summary.

learn more… | top users | synonyms

12
votes
2answers
65k 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 ...
22
votes
14answers
15k 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
361 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?
0
votes
2answers
133 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.