I would like to launch a toad script from MS Access. The script would call a Toad Stored procedure or SQL that would create a table. This table would be used by MS Access to create reports/pivot Tables/etc. Our company does not allow ODBC access to oracle whatsoever period. My hope would be to launch a script from Access that calls a toad procedure that gets data from Oracle and creates a table on my local drive. In summary MS Access => Toad =>Oracle. Can this be done?
Thanks in advance for the help