VBcoders Guest



Don't have an account yet? Register
 


Forgot Password?



Oracle-Excel

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.

Rate Oracle-Excel

Upload

Download this snippet    Add to My Saved Code

Oracle-Excel Comments

No comments have been posted about Oracle-Excel. Why not be the first to post a comment about Oracle-Excel.

Post your comment

Subject:
Message:
0/1000 characters