The query tag has no wiki summary.
16
votes
10answers
8k 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 ...
8
votes
1answer
30k 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 ...
3
votes
1answer
351 views
How can I get autocomplete to work (with a keyboard shortcut) with Sequel Pro?
If I type in a table name or part of a table name and wait a few seconds, a popup box will show up and allow me to choose a table or column. Is there a way to get this box to pop up without waiting - ...
3
votes
2answers
2k views
Pass parameter from Excel to Access query
I have a Access (2010 but I've also tried Office 2003) database with a lot of tables, forms and nested queries which rely on data entered in a form, e.g. WHERE query1.year=[Forms]![Form1]![Text0];. I ...
3
votes
3answers
24k views
Merge multiple columns into one via a query in an access database
i need to write a query that combines multiple columns of text.
my database is a database of wallpapers on my computer (i use john's background switcher), so i can easily find them and have them ...
2
votes
2answers
537 views
Foobar2000: any way to query whether a song is in a specific playlist?
In Foobar2000, I would like to make an autoplaylist that only shows songs that are not currently in another specific (manual) playlist.
Is there any way to query for this?
I imagine the query to ...
2
votes
1answer
2k views
How do you create a SQL query in Excel 2007 with a dynamic date range?
I am trying to create a reporting spreadsheet that can print reports for a given time period. The query below works, but when I try to use a ? parameter in place of the date, I get an error after ...
2
votes
1answer
353 views
Multiple tables in Microsoft Access that need to feed into one table
In my Access (2010) database, I have 4 linked tables (from other Access databases) that I would like to feed into one table, or query. I've tried using the query design but can't seem to get it right. ...
2
votes
1answer
485 views
How do I get Excel to run a query for each row in a spreadsheet?
Is there a way to run an MS Query for each row in a spreadsheet? For example, I have a sheet that looks like this:
CustomerID
111
222
333
I have the customer's address in a database, and I'd like ...
2
votes
2answers
162 views
Matching similar records in a database with Group By
I have a database in which there are company names each matched with the company post code. However there are duplicates since the company names are written multiple ways, like this:
Company Name ...
2
votes
1answer
804 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
873 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 ...
1
vote
2answers
2k views
Querying against Active Directory
I'm the "script guy" at my work, which is a blessing and a curse... I've been tasked with generating a script of:
Can you create a script to pull all users that have a proxy address
that is not ...
1
vote
2answers
1k views
Access 2007 create report from query
Where is my Query??? I'm using Access 2007, until this version I would create a query then create a report based in that query, using create-blank report. If I use the report wizard it does give me ...
1
vote
1answer
20 views
Filtering field on view - Lotus 8.5
I have one view with field that I called "Date".
I can´t filter the results for one date...
please help me.
1
vote
1answer
44 views
excel / open office - append an incrementing value to all non-unique fields
I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example:
store_1
store_2
etc.
Anyone know how to ...
1
vote
1answer
292 views
Does an anchor tag come before the query string or after?
I am unclear if an anchor tag should come before a query string or after.
http://www.domain.com/search?query=hello#name
or
http://www.domain.com/search#name?query=hello
Or does it matter?
1
vote
1answer
202 views
Query data in Powerpoint
I would like to build an MS PowerPoint 2010 presentation where some of the displayed data would be queried from an external source (I am flexible - the simpler the better, I need to update that ...
1
vote
1answer
377 views
Where is a Web Query stored in an excel file?
I have a Web Query looking at a site for data, and it gets the table selection wrong. Viewing source of the linked to web page I am able to identify the correct table.
In an Excel Web Query you are ...
1
vote
1answer
44 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
65 views
Exporting an SC query result to Excel
I wrote an SC query to show all the services and their state and I can easily display it in a text file. What I want to do is list all this data directly to an Excel worksheet.
How / is this ...
1
vote
1answer
72 views
Querying variables in Excel
I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type.
Here are some ...
1
vote
0answers
102 views
Change date in a SQL query to reference a cell in Excel
I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the ...
1
vote
1answer
506 views
Access query to combine two columns into one longer column with both sets of data
I need an MS Access query that will combine data from two identical fields in two different tables into one field. The two tables are "Payroll_2011" and "Payroll_2012"; and both tables have columns ...
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 ...
1
vote
2answers
465 views
Separate tables or single table with queries?
I'm making an employee information database. I need to handle employees that are separated from the company. Should I a. set up a query with a macro to send separated employees to a separate table, or ...
1
vote
2answers
698 views
SQL Server Management Studio Express - include date/time in Results or Messages
In SQL Server Management Studio Express 2005 is it possible to output the date and time that a query completed in the Results or Messages windows?
(without having to manually add a SELECT Getdate() ...
0
votes
3answers
642 views
Free Database Utilities / Tools for Mac OS X
If I were using Windows and wanted to use a database I would set up a WAMP server.
What can I use for Mac OS X?
I'm currently using SQLite via Mike's T Sqlite / Firefox addon for SQLite.
I would ...
0
votes
1answer
225 views
Query dpkg for All Packages Installed/Removed from Default Image
Is there any way to query dpkg to tell what packages have been added/removed since the base install of a system?
I am running Debian 5.
0
votes
1answer
81 views
Does MS Access update the data on the clipboard from a query when the data in the database changes?
I was just debugging a macro in MS Access, and when it hit the breakpoint ran a query and I copied the data from it to the clipboard. Some of the values were null before stepping to the next step, ...
0
votes
1answer
423 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
2answers
273 views
Is there a way to query file names in a directory within Access 2010?
Is there a native function for this within Access? Or would I have to do this with a batch script somehow?
Moreover, could I rename the files in a directory based on fields in an Access table?
0
votes
2answers
105 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.
0
votes
1answer
113 views
Simple fixes for improving multi-user MS Access performance?
I'm overhauling the entire IT infrastructure for a small office. They had a Dell T410 doing nothing but serving as a Win2k8 file share, so I figured I could replicate its functionality on an unused ...
0
votes
1answer
122 views
Upgrading from built-in Windows 7 32-bit to 64-bit? [duplicate]
Possible Duplicate:
Windows 7 and Vista Activation FAQ: How do language, version, 64-bit or 32-bit, and source affect ability to install and transfer Windows licenses?
Recently my hard ...
0
votes
2answers
201 views
TFS 2010 - Cannot query certain users
We seem to have an issue with out Team Foundation Server 2010 installation that gives an error when certain users are queried. If we include them in the 'AssignedTo' filter the query instantly errors ...
0
votes
1answer
508 views
Linked Query in MS Access 2007 to SQL database - ODBC error - How do I see the linking details?
I am converting an old Access 2003 database to 2007. It has a query linking to a SQL database. How do I look at the link, e.g., whether it using a DSN, etc.?
The query has the globe to the left of ...
0
votes
1answer
2k views
Combine fields from multiple tables in Access query
As an example, I have two queries in Access. The first outputs two columns:
| Cust ID | Revenue 1 |
| A | 5 |
| B | 10 |
The second query is similar:
| Cust ID | ...
0
votes
1answer
173 views
Graphical Decision Engine Framework - Any ideas?
Is there an open-source decision framework I could use?
What I am looking to create is some kind of graphical interface to allow people to visually build a query based on a set of parameters, ie. ...
0
votes
0answers
29 views
Network goes “Request Timed Out” when I run a query
I use postgreSQL 9.2 as the database and Java 6 as the programming language.
There is no problem when I run my program on the server computer. But when I run my program from a remote client, ...
0
votes
2answers
95 views
Is it possible to put a wildcard search into a parameter query in LibreOffice Base?
I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like:
SELECT * FROM ...
0
votes
0answers
49 views
Time truncation in database results in Excel 2013
We have an application built upon Excel (some querytables plus some VBA).
Behind that is an SQL Server query that returns some dates, date part of which is 1899-31-12. This date value is the "zero ...
0
votes
0answers
37 views
Can we write a SINGLE query for retrieving PROPERTIES from TWO CLASSES in WMIC?
I want to retrieve the data from multiple classes in single query in WMIC.
I know that it wont be possible in WMI. But somewhere i feel it can be possible in wmic.
also i am able to retrieve and push ...
0
votes
1answer
39 views
Managing records of bugs and notes
I want to create a knowledgebase for a piece of software. I'd also like to be able to track bugs and common points of failure in that application. Linking knowledgebase articles to bug records would ...
0
votes
0answers
354 views
Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today
I'd like to use Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today. Is there reserved name that I can use, like TODAY-30 under the filter criteria?
0
votes
2answers
528 views
Return cell reference as result of if statement with vlookups
I have two sets of data in excel. One contains a set of data which represents the initial step of a process. The other set of data represents the additional steps which take place after the first ...
-1
votes
0answers
22 views
what software can I use to show mapping of 2 database? [closed]
I have 2 database server main database A and other database B.
Database B is same as A but the name of tables and some of the field name are different, but data inside is almost the same.
Database B ...
