O2X - Convert ODBC to Excel XML 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!
Functions
Provides Excel / XLS (XML or CSV) spreadsheet file containing the contents
of an available ODBC Table.
Its as easy as 1 - 2 -3 !
- Select your Data Source
- Select a Table
- Press Fetch
Your new Excel spreadsheet 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!
Features
- Windows compatibility
- Speed
- ODBC compatibility
- Excel compatibility
- CSV export option
- XML export default
- Easy to use
- Command Line Options
- Save Settings and SQL for future use
- Execute Previous Settings and SQL
from you own application
- Select what Application to launch or keep the
Excel default
- Select what file name to create or keep the unique default
- Select whether
or not to Launch an Application
- Execute from the Command line or your own
application or script silently
- Power of SQL Syntax - if you need it!
