jWorkbook 2.0 - Free Download and Review

    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.





  jWorkbook 2.0 - Details and 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
  • Download link
 
Related keywords: database query queries sql Oracle Access SQL Server Excel tutorial

Top Software Development / Database & SQL programs

pgAdmin III for PostgreSQL 1)   pgAdmin III for PostgreSQL 1.02
Administration Centre for the PostgreSQL database, freeware

CuteSQL 2)   CuteSQL 1.2
CuteSQL allows you to execute SQL commands and queries against any database. Connections: Native, ODBC, ADO. Supported db: Oracle, MS SQL, PostgreSQL, MySQL. Features: tabular displaying of SQL queries; autocommit configuration; terminators settings.

Access-to-MySQL 3)   Access-to-MySQL 3.5
Access-to-MySQL is a program to move MS Access databases to MySQL server. All MS Access data types and attributes are supported. The program has easy-to-use wizard style interface and works with all versions of MySQL server.

IP2Location IP-COUNTRY-REGION-CITY Database 4)   IP2Location IP-COUNTRY-REGION-CITY Database March 2008
IP2Location(tm) IP-COUNTRY-REGION-CITY is commericial lookup database that translates IP address to country, region and city. Developers use this component for projects related to web, and client applications.

Access-to-Oracle 5)   Access-to-Oracle 1.3
Access-to-Oracle is a program to move MS Access databases to Oracle server. All MS Access data types and attributes are supported.

Database Workshop 6)   Database Workshop 5.52
Professional tool for managing, handling and analizing data bases with a wide range of possibilities. Supported database types: Paradox, DBase, Clarion, Interbase, MySql, EasyTable, DBISAM, MS Access, KeyDb, TinyDb, VolgaDb.

EMS SQL Manager 2005 for SQL Server 7)   EMS SQL Manager 2005 for SQL Server 3.0
EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features.

DTM Data Generator 8)   DTM Data Generator 1.19.10
DTM Data Generator is a simple, powerful and fully customizable tool that generates data for database testing. It creates test data, database tables and sets of INSERTS statements. The tool resolves foreign keys and order of tables automatically.

DBF to SQL 9)   DBF to SQL 2.00
The DBF to SQL program allows you to convert your dbf files to SQL script. You can apply this script on any SQL server, so you can easily transfer your data to a new system.

MSDE Manager 10)   MSDE Manager 4.32
Manage MSDE/SQL databases via an intuitive graphical interface and do all of the common operations that a typical deployment of MSDE/SQL would entail and much more besides. Add, edit and delete Databases, Tables, Views, Users, Rules, SP's & more.



New Software Development / Database & SQL programs

Excel Wordlist English Dutch 1)   Excel Wordlist English Dutch 1.0
Dictionary Database English Dutch to integrate into your applications in Excel Format. The demoversion includes the letter "W" with 1075 Keywords. Fullversion English Dutch Wordlist 37774 keywords with 37774 entries.

IntelliVIEW Dashboard Reporter 2)   IntelliVIEW Dashboard Reporter 4.0
IntelliVIEW Dashboard Reporter provides user-driven, interactive reporting & embedded analysis capabilities at a cost of traditional reporting! Users can visualize data & effectively monitor business performance without adding to the IT overhead.

ACCESS Wordlist English Dutch 3)   ACCESS Wordlist English Dutch 1.0
Dictionary Database English Dutch to integrate into your applications in MS-ACCESS Format. The demoversion includes the letter "W" with 1075 Keywords. Fullversion English Dutch Wordlist 37774 keywords with 37774 entries.

DBF Recovery 4)   DBF Recovery 2.0
If your DBF files have been damaged or corrupted, standard DBF readers won't work.DBF Recovery can repair your dbf files. Unlike most of the competitors, it not only fixes headers but also analyzes actual data structures and tries to fix them too.

ScimoreDB Distributed Server 5)   ScimoreDB Distributed Server 2.5.0.1053
Royalty free fully featured SQL database with nearly 1 million installations worldwide. Fast performance. Scales from small embedded to clustered ScimoreDB database for high load applications. Supports freetext indexing, acid transactions, T-SQL...

MDB2SQL Enterprise 6)   MDB2SQL Enterprise 2.10.48
MDB2SQL automates Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code.

Universal SQL Editor 7)   Universal SQL Editor 1.0.8
Allows you connect any ODBC compliant databases and edit SQL queries and scripts with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.

MDB2SQL Professional 8)   MDB2SQL Professional 2.10.48
MDB2SQL automates Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code.

DBF to XML 9)   DBF to XML 2.00
The DBF to XML program allows you to convert your dbf files to XML (Extensible Markup Language) format. XML is a universal data format. It is convenient for a migration of information to a new platform.

ModelRight Community 10)   ModelRight Community 3
Whether you are a beginner or an expert database modeler, ModelRight 3 is your answer when you need a database modeling tool that surpasses the "least common denominator" approach taken by others.

    Home
    Top Downloads
    New Programs
    Awards
    Link to us
    Submit
    Contact us

 


Scripts Categories

 

Game Cheats

 

Privacy Policy