DB2Excel

Hi guys,
I tried to create a program that will generate code that will export table contents to excel
and wanted other people to test my project. (P.S. Please excuse my coding, I'm just a starter with progress :}).

This program is created using Openedge 10.1B and tested using Microsoft Excel 2007
DB2Excel is a program that automatically generates code for importing data to excel.

Step 1: db2Excel Collects tables from the database and makes them available for selection.
(if needed for schema preview, you can edit the source code to view system tables)
Tables from Database gathered: Table SelectionTables from Database gathered: Table Selection

Step 2: After the table is selected. Press the button "show fields" to display the fields
of the selected table.
Select one or more field results to use for excel. (note: browsers are multi-selected)
Selecting Fields for Excel: Selection of Fields for excelSelecting Fields for Excel: Selection of Fields for excel

Step 3: You can add additional expression by selecting + right-click one or more fields from either browsers.
Step 4: Provide corresponding operator & values to the query created.
Add query for your program: Sample image how you create & modify query for your procedure.Add query for your program: Sample image how you create & modify query for your procedure.

Step 5: After enough information is given, Press 'Generate' to create a procedure for you query.
Note: Filename is needed with this operation.

Step 6: After generation of code, Click 'Excecute' button preview how the program will run.
Sample Preview of program excecution.: This is the result when you press 'Execute' button.Sample Preview of program excecution.: This is the result when you press 'Execute' button.

Advantages:
1. May be very useful as data migration utility.
2. Shortens coding time from 5 minutes to less than a minute (especially when you have include all fields of tables with many fields).

Any Comments or Suggestion are very welcome.
Please email me at gsanchezBiz@gmail.com

Thanks!


Releases



AttachmentSize
db2Excel.w33.74 KB