View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jamiee jamiee is offline
external usenet poster
 
Posts: 4
Default Connect to Oracle Database through ODBC with VBA

Hi

Could anyone give me some pointers as to how I can, through VBA,
connect to an oracle database, run a query on the database, and then
return one column of the results from the query to populate a listbox
on a VBA Userform in an Excel Spreadsheet?

Can I use DAO to connect to the database? and somehow place the
queryresults into a recordset which can then be placed into the
listbox.

Any help would be be appreciated.

Regards

J