Need some help in how best to implement and automated script that connects to an Oracle DB and runs some SQL queries, then exports the data to an excel file. First of all, I'm a bit of a newbie to this stuff. I have some knowledge of SQL, VBA and Excel macros. One challenge is the Oracle DB that I'm connecting to requires a VPN connection so I would like to automate that as well. Appreciate any thoughts on how best to do this and any more info or better description of what I'm trying to do I can give.