by Ben Slagmolen (1 Submission)
Category: Encryption
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: (4 Votes)
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.
Upload