 |
jWorkbook 2.0 |
| Publisher: | St James Software |
| Screenshot: | View Screenshots |
| Size: | 1.50 MB |
| Platform: | Windows |
| License: | Freeware |
| Updated: | 25 Feb, 2007 |
| Bookmark: |
|
| User Rating: | |
| Downloaded: 170 times |
jWorkbook Publisher's Description
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.
 | PEiD 0.95 Detects most common packers, cryptors,compile |
|
4/523 | |||||
 | CommLog for CE 0.3 WinCE tool of 5dtool for log com port data |
|
9/372 | |||||
 | SQL Developer 1.0 Develop and run SQL scripts with any DB |
|
2/295 | |||||
 | ConversionTool 4.2.2 Access to SQL Server, BTrieve re-engineering |
|
11/294 | |||||
| N2 Creator 2.0 N2 Digital Publishing and Broadcasting Wizard |
|
3/280 | |||||
| TransKing 2.0 VB and VB.NET to C# Converter Free Download |
|
3/245 | |||||
 | NeuroSolutions for MATLAB 2.00 Neural Network Toolbox for MATLAB & Simulink |
|
5/217 | |||||
| Multiport.USB 2.0 Organize a remote control of any equipment... |
|
1/214 | |||||
 | LTF-Cimulator 1.0 LTF-C neural network development tool |
|
1/201 | |||||
 | Leap SE 4.0 Leap SE turns requirements into object models |
|
1/197 |
 |
ISO Recorder: Burn your CD/DVD images fast and free
We all know that the default Windows burner lacks many options and it’s not a viable solution. There are many good programs that handle the CD/DVD burning jobs very good, such as Nero, but unfortunately, most are not free. However, there are several small applications that can handle certain CD/DVD burning tasks and one of [...] |
|
Apple advises the use of anti-virus solutions for Mac OS
It seems like the number of cyber criminals is growing and it reached the Mac users. The Mac systems were unaffected for a long time, the worst case scenarios were trojans that needed several confirmation from the user, to be installed and infect the system. Now, things may be a little different, as Apple posted [...] |
|
Play Windows Pong: The Pong browser game!
IF you don’t know what Pong is, I think you are not living on the right planet. Pong is the father of arcade games, originally released by Atari somewhere in 1972. Pong resembles table tennis, but in a more arcade-ish and simpler way. There are numerous versions of Pong, software AND hardware but people seem [...] |
|
How To: Split CSV files
CSV or Comma Separated Values, are files used by various software applications to export or import tabular data. The comma separated part comes in because the columns of each are separated using commas. The CSV format is very popular because many applications (online or offline) use this type of format to import or/and export CSV [...] |
|
Christmas themes for Mozilla Firefox
As Christmas approaches rapidly, many of us love to personalize our computers/laptops, being at work or at home. We can add that holiday touch to our computers, bringing the joy of winter and of course, Christmas, everywhere. And we should start with our browser, the main connection with the Internet. The most popular browser, Firefox, comes [...] |
|
CubicExplorer file manager: The Windows Explorer replacement
Many people like to replace Windows Explorer, the default file manager within the Windows OS. Now, there are many alternatives out there and some people including myself have more than 1 favorite file manager. CubicExplorer is one of those file managers that you install and like, period. It has a very simple interface and can [...] |
|
uTorrent for Mac beta launched and ready to be downloaded
Since not so long time ago, Mac users didn’t had any real torrent clients available. Transmission came into the set, but was very buggy, then Azureus ( now Vuze ), who was and is in my opinion a resource eater. At this moment, Transmission is the most viable solution for Mac OS, but let’s see [...] |
|
Fedora 10 is out, improved and download ready
The known Linux distribution, Fedora, received its well deserved update to its 10th version. The new Fedora 10 comes with many improvements and fixes such as loading times (including boot times), security tweaks, virtualization management and of course, networking improvements. The new Fedora distro comes bundled with OpenOffice 10, the latest build of OpenOffice, covering your [...] |
|
Wordpress 2.6.5 launched and download ready
Yesterday, the guys from Wordpress.org released the next version of the popular CMS, Wordpress. The 2.6.5 version doesn’t bring any features on the table, it’s more of a security update. If you want to see the changelog from the 2.6.3 version of Wordpress to the current one, please visit the Wordpress Trac. The biggest security fix [...] |
|
How To: Fix the Caps Lock, Shift, Control problem under Ubuntu
Many Ubuntu users have reported frequent problems within Ubuntu with the Caps Lock, Shift or the Control keys. The specified keys stop working randomly and an Ubuntu restart is required to re-enable them. While this problem isn’t a major one within Ubuntu, it’s not currently fixed or planned by the developers. There is however a fix, [...] |
CHM eBook Reader for Pocket PC is a program, that allows you to view files in the most common Windows help format (*.CHM, also known as "compiled HTML"), on the Pocket PC platform.
Key features:
Ope... 
Win/CE GPS client library component reads and decodes standard GPS NMEA 183 sentences from the RS232 serial port as well as compute great circle distances and bearings. Several eVC example programs wi... 
ElementaryExtensions is an experimental .NET targeted library which proposes some interesting ideas, strategies and techniques. It contains a set of miscellaneous helpers for different routine operati... 
Connect your mobile devices to remote FTP servers and transfer files with full directory management. The Sapphire FTP Utility gives you the ability to add file transfers and directory management with ... 
Virtual Serial Port ActiveX CE is a powerful ActiveX Control for Embedded platforms that allows your software to create custom additional virtual serial ports in Windows CE system and fully control th... 
Manage SIM card contacts, PIN details and call a phone number. The Sapphire SIM Function Library provides the Visual Studio developer with the ability to manage the SIM card of a Pocket PC Phone Editi... 
DocArchitector provides all necessary features for developing professional help files and manuals in CHM format: WYSIWYG HTML Editor with all necessary tools for creating HTML pages, HTML Code editor ... 
30 day SDK trial includes library, C/C++ programming samples, scanner drivers for Linux. Integration into ARM-based devices with ARM Linux or MS Windows Mobile. Constant internet connection required d...