Oracle-Excel
The purpose of this program is to retrieve data from an Oracle Database and write it directly to an Excel worksheet, enabling me to fully automate weekly reports.
This example will translate any SQL-script to an Excel worksheet and even format the worksheet for ya...;-)
Assumes
You do have to understand a little bit about Database queries
Side Effects
For some reason it will not work properly when Excel is allready opened.
Rate Oracle-Excel
(5(5 Vote))
(5(5 Vote))
Active Server Pages
Coding Standards
Complete Applications
Custom Controls
Data Structures
Databases / ADO
DDE
Debugging & Errors
DirectX
Encryption
Files / I/O
Games
Graphics
Internet / HTML
Jokes / Humor
Libraries
Math / Dates
Office / VBA
Miscellaneous
OOP
OLE / COM / ActiveX
Registry
Sound / MP3
String Manipulation
VB Enhancements
Windows API
Windows CE
System Services