O2X - Convert ODBC to Excel XML, HTML or CSV! O2X (odbc2xls) offers the user a simple, fast and effective method to extract ODBC Table Data from the local ODBC driver into an application, like Excel, as a Spreadsheet via XML or as a CSV (comma seperated values) file. With an easy to use windows interface, the user just selects an ODBC database and table and then presses one button to fetch the entire contents into a ready to use excel (xml or csv based) spreadsheet or other application for display. You can even execute it from your program or the command line transparently! NOW with Excell 2007 ( and 2010 ) Compatibility Mode

Try this utility for free and then
purchase for only 10$!
Now at Version 3.1.2!

[Support] [Functions] [Features] [Updates]
[Command Line Args] [Source Code Examples]
[Usage] [Output] [Screen Shot] [Demos]
[Download] [Awards] [Purchase]

.

Functions

Provides Excel / XLS (XML or CSV) spreadsheet file (or even an HTML Table) containing the contents of an available ODBC Table.
Its as easy as 1 - 2 -3 !

1. Select your Data Source
2. Select a Table
3. Press Fetch

Your new Excel spreadsheet (or web page) with the entire dataset will automatically be loaded for you and will display on the screen ready for you to modify and save for further use! You can even, optionally, narrow your query by editing the SQL and get exactly the table field information you want and need!

ODBC2XLS will even allow you to grab the ODBC data by executing directly from your own application or from the command line. When used like this, ODBC2XLS can run in silent mode, where the user never even sees the application run! That just get the results they need, from the interface you provide!

.

[ back to top ]

.

Features

1. Windows compatibility
2. Speed
3. ODBC compatibility
4. Excel compatibility
5. CSV export option
6. XML export default
7. HTML export option
8. Easy to use
9. Command Line Options
10. Save Settings and SQL for future use
11. Execute Previous Settings and SQL from you own application
12. Select what Application to launch or keep the Excel default
13. Select what file name to create or keep the unique default
14. Select whether or not to Launch an Application
15. Execute from the Command line or your own application or script silently
16. Power of SQL Syntax - if you need it!

[ back to top ]

.

Updates

Version 3.1.2 released

Fixed fsql bug that
sometimes prevented csv output.

Version 3.1.1 released

Added 2007 Compatibility Option
( Max Rows goes from 65534 to 1048576 )

Changed Silent Mode to not warn on Empty results

Version 2.7.5 released

Improved handling of null values.

New 'Force Full Length' option.

Version 2.6 released

Improved encryption algorythm!

Password encryption improved to handle fsql session line feed concerns.

Version 2.5.0 released

New HTML Out!

You can now select HTML as an output preference.
This allows you to create an HTML table directly from your ODBC data source.
You can save huge amounts of time with this new feature!

Also improved Exception handling and improved support for many Table Column Types.

Version 2.0.2 released

The new Features keep coming!

An advanced section has been added to the
windows and command line interface, allowing:

Selection of the Application to Launch at the end of the data extraction

Selection to Turn off Application Launch at the end of the data extraction.

Selection of the output file name.

Click Here for demos.

Version 1.5 released

Even more Major new Features !

You can now save your current settings and SQL statement to be used later!

You can now load old session settings from the command line or the Windows interface!

You can now execute ODBC2XLS silently!

Click Here for demos.

Read more about the changes in the Support Forum

Version 1.1 released

Major new Feature !

You can now edit the SQL statement used to generate your Spreadsheet data!

Click Here for demos.

Read more about the changes in the Support Forum

[ back to top ]

Example Usages

Want to use Microsoft SQL Server data without having to learn SQL?

Want to grab MySQL data into a csv file?

Want to take advantage of Excel's graphing capabilities on a system database table without having to use macros and scripting to connect via ODBC?

Want to pull in database data into an application that only accepts csv import?

Want to present your data in a read only / safe web page?

Want to extract data from an Access Database into an Excel Spreadsheet?

Want to get database information into excel and avoid having to use SQL ?

Want to backup important information from an ODBC data source to csv ?

Want to add your data to an existing web site?

Want to get just the Customer Names and Phone Numbers from your database of thousands of records?

Want to graph units sold from your DSN using Excel?

Want to add Excel output to your program?

Want to add a table to your HTML page?

Need to Export CSV from your Batch file?

Want to execute an application that accepts a csv input?

[ back to top ]

.

Example Outputs

• An Excel Spreadsheet (is automatically loaded and ready to use!)
• A CSV (comma separated values) text file
• A HTML (hyper text markup language) table web page.
• A XML (extensible markup file) in Excel compatible format

[ back to top ]

Screen Shot

Demos

Demo 1	Demo 2	Demo 3
Change Default SQL	Quick and Easy	Save Settings

Demo 4	Demo 5	Demo 6
Load Settings	Execute Silently	Execute From Command Line

[ back to top ]

Command Line Options

[ back to top ]

Source Code Examples

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
' Excute ODBC2XLS against x.fsql silently -> From O2X-demo1
Shell("C:\Program Files\BitDaddys Corp\ODBC2XLS\Database\odbc2xls.exe -file=""x.fsql"" -silent", 
      AppWinStyle.NormalFocus)
End Sub

		
private void button1_Click(object sender, System.EventArgs e)
{
// Excute ODBC2XLS against x.fsql silently -> From O2X-demo2
System.Diagnostics.Process.Start("C:\\Program Files\\BitDaddys Corp\\ODBC2XLS\\Database\\odbc2xls.exe",
                                 " -file=\"x.fsql\" -silent\"");
}

[ back to top ]

Trial Version Downloads

[ back to top ]

Awards

[ back to top ]

Purchase

10$ for the full registered version.

(the registered version may be a newer revision and include additional features and functionality than provided in the trial version)

.

[ back to top ]

.

.