jWorkbook Free Download at datapicks.com - create, manage and run sql from inside Excel. results saved to spreadsheet

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.

Top Database & SQL / Software Development programs

1) CASE Studio 2 v 2.23
Powerful database design tool which allows you to visually create Entity Relationship Diagrams (ERD) for various database systems - MS SQL, Oracle, DB2, MySQL, InterBase, Sybase etc. Features: ERD, SQL script generation, Reverse engineering...

2) Visual Open DB 1.75
Visual Open DB is a generic data analysing application that allows you to query any valid data source. It can be used by end users to perform data analysis and developers to interrogate database tables and views.

3) Aqua Data Studio 4.0
Aqua Data Studio is a SQL editor and developer tool that allows developers to easily create edit and execute SQL scripts as well as browse database structures

4) DBF Viewer 2000 2.45
DBF Viewer 2000 is a powerful, compact and easy-to-use viewer and editor for DBF files. You can view, edit, sort, use query by example, delete duplicates, create, print database tables a export the data from them to a variety of formats.

5) 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.

6) DBF to CSV 2.01
The DBF to CSV program allows you to convert your dbf files to csv (comma-separated value) format. Generally, you can use any delimiter, such as TAB, semicolon etc. The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats

7) TOAD for Oracle Freeware 8.5
TOAD® empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. TOAD is a powerful, low-overhead tool that makes PL/SQL development faster and easier and simplifies database administration.

8) SQLite3 database manager LITE 3.1
SQLite3 database manager. Development tool for managing all database objects. SQL builder.

9) GIS ObjectLand 2.6.5
GIS ObjectLand is a universal Geographic Information System for Windows. Key features: vector-raster maps; multiuser data editing; import/export for MIF/MID, SHP, DXF, DBF, CSV; access permissions for users; using other DBMS (ODBC); COM interfaces.

10) 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.

New Database & SQL / Software Development programs

1) MyDeveloper Studio 3.00 beta
Powerful database development and administration environment for MySQL. Presents a large set of database tools for simplifying interaction with MySQL and automating the database development process. Has a unique built-in stored routine debugger.

2) SQL Data Examiner 2.2.0.20
SQL Data Examiner 2008 is a multi-platform data comparison and synchronization tool that merges selected databases with just a few clicks. The tool simplifies the process of data migration and saves hours of boring manual work.

3) Mexico Postal Code Database (Gold Edition) July.2008
Mexico postal codes database subscription. The database includes postal code, city name, colony name, state code, state name, latitude and longitude, time zone and area code in Mexico.

4) MS Access Print Multiple Objects Software 7.0
Print many MS Access tables, queries, forms, pages, modules, macros and reports without having to open each one. MS Access 2000 or higher required.

5) Oracle Copy Tables to Another Oracle Database Software 7.0
Copy tables from one Oracle database to another. Provide the login information for both databases.

6) FoxPro Copy Tables to Another FoxPro Database Software 7.0
Copy tables from one FoxPro database to another. Provide the file locations for both databases to connect. Connect to FoxPro via DBC file or multiple DBF files in a folder.

7) Export Query to Text for SQL Server 1.04.22
Export Query for Microsoft SQL Server helps to save a query results to text file. The program supports delimited or fixed length formats. Export utility has easy to learn and to use wizard interface. All modern versions of SQL Server are supported.

8) MySQL Copy Tables to Another MySQL Database Software 7.0
Copy tables from one MySQL server to another. Provide the login information for both databases.

9) MS Access Copy Tables to Another Access Database Software 7.0
Copy tables from one Access database to another.

10) SQL Script Builder 1.6.3.53
SQL Script Builder is powerful software that create a database file or sql script from any ODBC data source. The script or file will migrate the table(s) and the records. Scripts comes in 5 formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL.