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

Recommended Software

CyberLink PowerDVD

CyberLink PowerDVD 11

PowerDVD 11 is the ultimate universal media and Blu-ray player that extends your viewing experience beyond just movies. Play Blu-ray Discs, DVDs, video files, music, and now you can even view photos, all from one universal player. Stream content from your smart device, DLNA server or cloud to...

DOWNLOAD
 
 

jWorkbook

jWorkbook 2.0

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: 15

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 XP, Windows 2000
Language Support: English

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

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

  • 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
  • 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 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.
  • Easy Query Builder Icon Easy Query Builder - Easy Query Builder is an SQL query builder for users who need to extract data from databases with as little effort and knowledge as possible. It allows users to extract data by translating natural language queries into correct SQL statements.
  • Universal SQL Editor Icon Universal SQL Editor - Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc., with SQL formatter/beauifier, query result supports grouping, filtering, searching, and can also be exported to Excel spreadsheet or as a set of SQL statements.
  • Smart Contacts Synchronizer Icon Smart Contacts Synchronizer - Sync any database such as Ms Access,Excel, Oracle,MySQL with SmartPhone Contacts Overwrite/Adds any Desktop database to SmartPhone Contacts or vice versa. Supported Databases: MS Access, MS FoxPro, Oracle, SQL Server, MS dBase, MySQL etc.
  • 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.
  • 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.
  • No Icon BlackBerry Database Viewer Plus - View and sync Microsoft Access, Excel, Foxpro,Oracle, SQL Server or any ODBC enabled database on BlackBerry.Update data on BlackBerry. Make a phone call from transferred database. Create new database on BlackBerry. Export record to Memo Pad.
  • No Icon Database ViewerPlus(Access,Excel,Oracle) - View and Syn Microsoft Access, Excel, Oracle, Foxpro, dBase or any ODBC enabled database with palm.Add, Delete, Modify Database records on palm. Get updated desktop data on palm and palm data on desktop automatically. Create database on Palm.
 

Actual Software | Link To Us | Links | Contact

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