Main Menu
Home
Top Downloads
New Programs
Awards
Link To Us
Submit Programs
Bookmark
Contact Us

Programs Categories
  ·  Active X
  ·  Basic & VB & VB DotNet
  ·  C & C++
  ·  Compilers & Interpreters
  ·  Components & Libraries
  ·  Database & SQL
  ·  Debugging
  ·  Editors & Tools
  ·  Help Tools
  ·  Install & Setup
  ·  Java & JavaScript
  ·  Others
  ·  PHP & ASP & HTML
  ·  Source Editors
  ·  XML
 


 

jWorkbook 2.0

   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!

<http://sjslive/products/images/HandIcon.gif> 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.




Download link
Size 1536KB
License Freeware
Price 0
Category Programming & Software Development / Database & SQL
Operating System Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000
Developer St James Software

  
Top Database & SQL / Software Development programs
  • DBi-DScript  1)   DBi-DScript 1.01
    Create hundreds of meaningful data records instantly. DBi-DScript allows developers to create usable data records. Stop creating valid data records by hand, or dealing with useless data to test your app.

  • Access2MySQL SYNC  3)   Access2MySQL SYNC 4.0.3
    Access2MySQL Sync with built-in scheduler performs MS Access (mdb) to MySQL and MySQL to Access database conversion with synchronization and ability to choose particular tables to be converted simply by configuring options in wizard-like application.

  • BITE SQL Reports  4)   BITE SQL Reports 1.01a
    SQL reporting software that can be "plugged" into any existing database to add advanced reporting capabilities. You can build reports, and store them in the very same database. View, Print, Save and FTP these reports to pre-define places.

  • Stored Procedure Proxy Generator  5)   Stored Procedure Proxy Generator 1.1
    Stored Procedure Proxy Generator is automatic generation proxy utility of database stored procedures for simplifying calling stored procedures from Microsoft .NET Framework programs.

  • Courier  6)   Courier 2.0
    This is for anyone who has a small or private courier business. Now you can easily keep track of customers. You can know ata glance what customer uses your business the most.

  • Reconcile Query Wizard Add-In For Access  7)   Reconcile Query Wizard Add-In For Access 1.2
    Free utility to build a reconciliation query that identifies differences between two tables in Access. Easy-to-use wizard guides you through the simple steps to build your reconciliation query.

  • DB Explorer  8)   DB Explorer 3.0.0
    Compare two database schemas and/or table data rows and report differences. Synchronise the differences for one or other database. Sync Schema generates the SQL DDL statements. Sync Data either transfers the rows or generates SQL DML statements.

  • Apex SQL Edit  9)   Apex SQL Edit 2.20
    Apex SQL Edit is a complete development, editing and deployment environment for SQL Server Developers. Apex SQL Edit provides Visual Source Safe Integration and powerful features not found on other SQL editors

  • SQLTools  10)   SQLTools 1.4.1 build 66
    SQLTools is a light weighted and robust tool for Oracle database development. It includes a text editor, an sql console and a couple of sql utilities. You can use it for dial-up connection and it will work as fast as SQLPlus.


New Database & SQL / Software Development programs
  • Geodaten German Houses (English)  1)   Geodaten German Houses (English) 1.00
    For the area of the Federal Republic of Germany more than 19 million house coordinates with a coverage of 100% are available. The geo data offered here are in high-precision quality and are present in different coordinate and reference systems.

  • NET Reports Server PRO  2)   NET Reports Server PRO 2.0
    NET Reports 2.0 Server - a Internet ready application; Fast Query & Report solution for Ms.Sql Server, Oracle, PostGreSql, MySql, Interbase, Firebird, MS. VFP. Sybase, MS. Access; Free client software from http://www.net-reports.net/downloads.html

  • Reportizer  3)   Reportizer 2.6
    Database reporting tool. Easy creating, modifying and printing database reports. Supports BDE or ADO databases.

  • Exportizer Pro  4)   Exportizer Pro 3.7
    Exports database tables (DB, DBF, MDB, XLS, GDB, IB, HTML, UDL, TXT, CSV) to clipboard or file (XLS, RTF, XML, HTML, TXT, CSV, DBF). Many options allow full control over output.

  • Exportizer  5)   Exportizer 3.7
    Exports database (DB, DBF, TXT, CSV, etc.) to clipboard or file (XLS, RTF, XML, HTML, TXT, CSV, DBF). Many options allow full control over output.

  • Database Tour Pro  6)   Database Tour Pro 5.3.0.764
    Universal database tool with report builder. Viewing, editing, and printing data; building SQL queries; building reports; sorting and filtering; viewing and printing structure; searching and replacing text; importing and exporting data.

  • Database Tour  7)   Database Tour 5.3.0.764
    Universal database tool. It allows viewing, editing, and printing data, building SQL queries, sorting and filtering, viewing and printing structure, reindexing, searching and replacing text, importing and exporting data.

  • DBDocumentor  8)   DBDocumentor 4.20
    Document and report on the SQL objects making up your SQL database. DBDocumentor describes all SQL objects in the database, and includes parameter, result set and data usage listings. Output options include colorized source code and XML.

  • TOAD for DB2 UDB  9)   TOAD for DB2 UDB 1.0.2.837
    Toad® for DB2 UDB is a database development solution that provides productivity features for rapidly creating and executing queries, automating database object management, developing SQL code, and instant access to DB2 expertise.

  • TOAD for SQL Server  10)   TOAD for SQL Server 2.0
    Toad for SQL Server leverages Quest Software's database expertise to empower SQL developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management and develop SQL code more efficiently.


 


 


© 2006 - 2008 ProgramsBase.com - Privacy Policy