PDA

View Full Version : How to query oracle using VBA



n2porsche
03-17-2014, 01:19 PM
I want to use vba to query oracle at excel start-up and have a few fields of the 10 or so records retrieved presented to a user in a list box. Hopefully, I can have the fields scroll synchronously. I know oracle sql and vba decently, but know nothing about connecting them. I poked around and got some alphabet soup: ADO, DAO, ODBC, OLE. I have no idea what these are, but in looking on MSDN it seems each of them is being phased out. I need to write a small app, maybe 1k lines, and not have to worry about recoding it for a few years. So, what is the current preferred methodology for doing this? I've seen various examples of this, but is there a comprehensive syntax reference somewhere? TIA