Main > Software Creation > MySQL , MsSQL & Databases > jWorkbook by St James Software
jWorkbook 2.0
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.
To link jWorkbook, use the following code:
If you want to link main page only, you may use this logo: 
Write a short review to jWorkbook freeware
Suggested MySQL , MsSQL & Databases downloads
SwisSQL - Data Migration Tool 5.5
AdventNet SwisSQL offers a complete Data Migration Tool that helps the migration of database structures and data across leading databases such as Oracle, IBM DB2, MS-SQL Server, Sybase, SAP DB, PostgreSQL and MySQL. It offers an open, user-friendly,...
MDB2SQL Enterprise 2.8.85
MDB2SQL automates Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code. MDB2SQL can quickly and cost-effectively convert your Access (.mdb) databases to use SQL Server – without...
dataPro 1.5.6
dataPro is an advanced visual cross-platform database management, development and conversion tool. Transfer data between databases, run SQL queries, view data and export result of the query to the Excel file, text file, xml file or SQL script....
DTM SQL editor 2.02.97
DTM SQL editor is a set of powerful database management tools that allow you to achieve two goals: to have unified access to different types of databases and to have a set of solutions that makes processing your data easy....
DataRoamer 2
DataRoamer is a tool for easily exploring the structure and data in a relational database. DataRoamer`s GUI interface provides point and click schema navigation and queries. Features include: Tree-like navigation of the database schema. Point an...



