Can Excel be used to access and make queries into an Oracle database?
We sometimes use MS Access to do this but prefer to do it in Excel, if possible, as all our users have Excel. Thank you.

It's easiest to use ODBC driver which somes with MS Query. Select "New Database Query..." From "Data->Get External Data..." Menu. Select New Database option then follow the wizard to select driver and define source. After defined you can attach it to the workbook and set options to update on open, remember password. etc.


/*