Must Have | TOP 100 | Authors | Reviews | RSS | Submit

Recommended Software

GetRight Pro

GetRight Pro 6.2a

GetRight Pro does everything a download manager can do and more. It can of course accelerate, resume and schedule your downloads. GetRight Pro goes beyond by allowing you to upload files, it can quickly scan to find just which files to upload to update your website. It supports scripting, it...

DOWNLOAD
 
 

jWorkbook

jWorkbook 2.0

jWorkbook Screenshot

Category: Developer Tools / Databases & Networks | Author: St James Software

jWorkbook is an Excel Add-In that enables you to build powerful database queries and see the results directly in your Excel Spreadsheet. Build reports quickly using single or multiple SQL statements. Supports Oracle, Access and SQL Server.

DOWNLOAD Cost: $0.00 USD
License: Freeware
Size: 1.5 MB
Download Counter: 10

jWorkBook: Get Database information directly into your spreadsheet
Now a quick way to get the information that is currently in your system databases directly into your spreadsheet. jWorkbook is an Excel Add-In that enables you to build powerful queries to access the information directly and see the information in your Excel Spreadsheet. You can build reports quickly and interactively using the power of single or multiple SQL So.... the information you need is stored in the Oracle, Access or SQL database and you need to look at it and do some calcs and write a quick report? What are your options? Simple, find a programmer, tear him or her away from the thousand other jobs on the go and try to explain what you want. They will put your request into a queue and hey presto 3 months later you get the information you want...if you are lucky!

Enter jWorkBook: start up Excel, enter a simple SQL command....bang the information is there!
Not quite what you want? No problem, refine the command and run it again. Or add another command and run them both. Format the output in your spreadsheet, add a chart and you have your data in the format you want in a couple of minutes. Really that simple? You bet.
SQL is by far the most popular database language available today. It is used as the main form of communication by every database of note. It is extraordinarily powerful. But best of all, to do the vast majority of tasks, it is extremely simple. Unlike languages like C or Basic, you can do most of your data retrieval commands in a single statement. It is a fact that if you understand the English-like Select statement, you are probably 99% of the way to being self sufficient in retrieving your data from the database. Granted, as you get proficient in SQL, you will naturally extend your skills to more exotic structures but from day one, you are productive. But don't take our word for it, run through the tutorial and give it a try.

Requirements: Excel 2000 or higher
OS Support: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP
Language Support: English

Released: January 01, 2002 | Added: January 01, 2003 | Viewed: 63
 

Related Software

Access | Access Database | Access Query Generator | Convert Access To Oracle | Convert Oracle To Access | Database | Database Query | Database Query Tool | Excel | Ms Access Database | Oracle | Oracle Database | Oracle To Excel | Queries | Query | Query Database | Server | Sql | Tutorial

  • Oracle Query Analyser Icon Oracle Query Analyser - Oracle Query Analyser allows rapid transact SQL development against an Oracle database through an intuitive Windows graphical user interface.
  • No Icon SQL Excel - Freeware Excel Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase, MY SQL and any other ODBC compliant database. For more information, please look at http://www.sqlexcel.net
  • Query Tool (using ADO) Icon Query Tool (using ADO) - Query OLE DB data sources, author SQL scripts and queries, execute multiple SQL scripts or stored procedures simultaneously, and more.
  • Database Assistant Icon Database Assistant - Manipulate data from a variety of database formats including Oracle, SQL Server, Informix, MS Access, and Sybase et al with the Markosoft Database Assistant.
  • No Icon Smart Database Viewer(Access,Excel,Oracle) - View any desktop database on Smart Phone. Use desktop application to convert your MS Access, Foxpro, dBase, Excel, MySQL, or any ODBC Compliant database to PDB and use DatabaseViewer.exe to view it on Smart Phone.
  • Active Query Builder Delphi VCL Edition Icon Active Query Builder Delphi VCL Edition - Active Query Builder is a Delphi VCL component to create SQL queries easily. True two-way query builder with user-friendly interface and unique query research capabilities; a perfect choice for both SQL beginners and experienced query writers.
  • Odbc 4 All Icon Odbc 4 All - Allows any application, including DOS apps and batch files, to easily run SQL queries using any ODBC data source, (Access, MySql, Oracle, Informix, ...) redirecting the output to the screen, an ascii file / table or a DBF table.
  • dbQwikEdit PRO Icon dbQwikEdit PRO - Easy to use advanced SQL tool. Lets you open any database, edit data, design tables, create queries, import and export data and generate complex SQL statements with ease. Suitable for both novice users and power users. Works with all data bases.
  • 4TOPS Query Tree Editor for MS Access Icon 4TOPS Query Tree Editor for MS Access - 4TOPS Query Tree Editor? for MS Access for query development. Edit and run queries from a tree dialog showing query dependencies (Uses / Used By)
  • Active Query Builder ActiveX Edition Icon Active Query Builder ActiveX Edition - Active Query builder is a .Net-ready ActiveX control to create SQL queries easily. True two-way query builder with user-friendly interface and unique query research capabilities; a perfect choice for both SQL beginners and experienced query writers.
 

Actual Software | Link To Us | Links | Contact

Must Have | TOP 100 | Authors | Reviews | RSS | Submit