Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Pull data into Microsoft Excel with Web queries
- An Excel Web query allows you to bring data from a Web siteinto an Excel worksheet. It will find any tables on the Web page and let youselect the ones containing data you want to put into your worksheet, allowingfor dynamic updates from the Web page. Web queries are not...
- Tags: Justin James, Microsoft Corp., Microsoft Excel, Web, Web Query
- Technical articles 2006-09-14
- Pull data into Microsoft Excel with Web queries
- Do you use Web queries to bring data into your Excel worksheets? Have you run into any roadblocks when trying to run them?POST versionI'm trying to create the equivalent of your sample xls for the following URL:http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol=GOOG&lstStatement=Income&stmtView=AnnCreating the IQY is no problem:WEB1http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol=["Stock"]&lstStatement=Income&stmtView=Annbut when I go to edit the query to...
- Tags: correct table, excel, hardware, JodyGilbert, justin james, Microsoft Corp., Microsoft Excel, stock, stock price, vba, Web, Web Query
- Discussion threads 2006-09-15
- Get up-to-the minute data with Excel's automatic Web queries
- When your job depends on having the latest stats, it behooves you to find the most efficient way to receive this information. Discover how Excel 2002 and 2003's Web query feature allows your spreadsheet to automatically update the data from the Internet each time you open the file. If...
- Tags: Web, Microsoft Excel, Microsoft Office, Mary Ann Richardson, Channel management, PRODUCTIVITY, Web Query, Click OK, Go-to Edit, Microsoft Office Suite Excel Tips Newsletter, Team, Data, Spreadsheet, Team Management, Office Suites, Software, Marketing, Management
- Technical articles 2005-07-12
- Creating dynamic spreadsheets in Excel
- Consultants who need to provide Web-based data to a client's users can use Excel's Web query functions to create dynamic spreadsheets. We'll show you how to do it in both the old and new versions of Excel.As a consultant, framing your work in ways that are familiar to your client...
- Tags: Microsoft Office, Channel management, Les Hamilton, Figure E, Microsoft Excel, Web Query, Web, spreadsheet
- Technical articles 2001-08-29
Additional Resources
- how to write a search query
- I am using asp.net 2 with visual web developer express and mssql express database. My question is how do i write a query i am writing query in mysql the same query how do i write microsoft sql serverselect * from emp where city like "ca*";
- Tags: mssql, zubin@..., MySQL, programming, windows, SQL
- Discussion threads 2006-12-04
- Query Maker (zip)
- Microsoft .Net class library allows developers to programmatically query anything off of a Web site, converting data to name-value lists or DataTable objects. Query class can navigate multiple pages in one method call. A structured query configuration file is used to define queries, which can then be handed to the...
- Tags: Query, Microsoft .Net Class Library, Data, Web Site Development, .Net, Web Technology, Application Servers, Channel Management, Middleware, Internet, Software Development, Software/Web Development, Enterprise Software, Software, Marketing
- Software downloads 2005-02-09
- SPARQL: A query platform for Web 2.0 and the Semantic Web
- The Web 2.0 and Semantic Web are two common ideas that form a basis for the future of the World Wide Web. The main principle outlined by both paradigms is an ability to extract and query information across the informational space which includes Web sites, documents, databases, Web services, libraries...
- Tags: Web, Web 2.0, Semantic Web, Channel Management, Internet, Marketing
- Download resources 2006-07-20
- A Study of Real-Time Query Expansion Effectiveness
- This paper describes the study of an interface technique that provides a list of suggested additional query terms as a searcher types a search query, in effect offering Interactive Query Expansion IQE options while the query is formulated. Analysis of the results shows that offering IQE during query formulation leads...
- Tags: Query, Study, Productivity
- White papers 2006-08-06
- Quintura Search (exe)
- Quintura Search offers a visual search using a map of tags or hints contextually related to a search query. Adding or subtracting tags from the query with a mouse click, One-Click-Search, allows to specify the context or meaning of the query. Using Quintura Search, you can create a search scope...
- Tags: Query, Quintura Search, Search, Channel Management, Mice, Marketing, Hardware, Peripherals
- Software downloads 2006-03-01
- sql query optimization
- my query is taking some 2029 msec to execute and my client requirment is it must be atleast reduced to 30% , i had created the indexes on the coloumns in the where clauses, and passed parameters to the coloumns and tried but still the performance didnt improved can...
- Tags: Performance management, Servers, OPEN SOURCE, neelu_munna@...
- Discussion threads 2007-06-14
- Creating a Query
- I have created a query but when I print a report from the query, one of the field is pulling the primary key as the info instead of the name of the site, which is what I want. How do I create the query to pull the name of...
- Tags: cjones@...
- Discussion threads 2007-06-04
- Display two queries and include a 'Reason' column.
- I'd like to combine the results of two query expressions into one query table.MsAccess I don't want to use a UNION, since I need the database to be edited from the resultant query. So far this much I have no problem doing. The problem is that I...
- Tags: bjappel@...
- Discussion threads 2007-11-01
- Microsoft Access 2000
- In a database file of 1000 names, how do I enter a check character in a field called MAILso that all records indicate YES. I know I can do it manually one record at a time, but is there a way to modify the table or create a query...
- Tags: Databases, Microsoft Corp., Microsoft Access, RCBLT@...
- Discussion threads 2007-04-13
- HP Neoview Parallel Query Optimizer
- The HP Neoview data warehousing platform can deliver enormous parallel power from its scaled-out grid of hundreds of commodity servers because of its industry-leading query optimizer. The Neoview Parallel Query Optimizer is unique in its ability to transform any query into a query plan that will use all of the...
- Tags: Hewlett-Packard Co., Neoview Parallel Query Optimizer, Business Intelligence, Storage, Databases, Enterprise Software, Software, Data Management, Hardware
- White papers 2007-01-01
- 4TOPS Query Tree Editor for MS Access (exe)
- 4TOPS Query Tree Editor is an add-in for MS Access for query development. Create queries using templates. Edit and run queries from a tree dialog. The Query Tree dialog displays the dependency tree of the selected query (Uses / Used By). The buttons on the dialogs support a natural way...
- Tags: Microsoft Access, 4TOPS, Microsoft Corp., 4TOPS Query Tree Editor, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Software downloads 2006-10-09
- SquishQL: The simplest RDF query language
- RDF is a main standard for metadata defining and storage in a Web 2.0 environment. However, most of the query languages are incomplete and fairly complex. However, accessing RDF data is a simple thing when you use SquishQL - an RDF query language with SQL notation. Using several code examples,...
- Tags: RDF, XML, Internet, Software/Web Development, Web Development
- Download resources 2006-07-24
- Query - Last 6 months
- Greetings,I need help w/ a query. Ideally I would like to pull all records from two tables for the previous 6 months. I have considered using a parameter query, but it would be better if it could be automated. Any help would be greatly appreciated.Thanks,Natalie
- Tags: n.smith326@...
- Discussion threads 2007-11-06
- Quick Query (exe)
- Quick Query is a Plug-In for Microsoft Access. It provides a context sensitive, simple way to perform SQL queries on the fly, without creating or saving a query using the standard Query Designer. You can also create queries too complex for the Query Designer. Keywords, restricted words and symbols, brackets...
- Tags: Query, Quick Query, Construction, Databases, Programming Languages, Microsoft Office, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Office Suites
- Software downloads 2006-10-02
- AQL Query Analyser (exe)
- Database query analyser. Connect to any database type. Execute SQL in multiple windows. Export output in a variety of formats. Ideal for non DB specialists who require the ability to query a database or specialists who need to query different databases from a single application. This version is the first...
- Tags: Sirius, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2008-07-31
- WMI Query (widget)
- WMI Query is a tool for querying the WMI Interface in Windows with tons of system information. I use it to see how many user sessions are logged on to my Web site at any given moment. This version is the first release on CNET Download.com.
- Tags: WMI, WMI Query, Network Administration, Networking
- Software downloads 2007-11-07
- << Previous
- page 1 of 1
- Next >>
