Using MS Access to Manipulate Excel Workbook

  • Thread starter Thread starter ISUTri
  • Start date Start date
I

ISUTri

I have an Excel Workbook that is a front end to an Oracle databse
(9i). The excel spreadsheet has a button I click to Logon to the
Oracle database and then it has another button I click that brings up
a box where I enter my SQL Code. I was wondering if there was anyway
I can do this through Access? So that Access will log me on to this
spreadsheet and send the SQL Code that I want to use..

Thanks for any help
 
Unfortunately, the answer is "it depends".

Try recording a macro in Excel while you're logging onto Oracle and entering
the SQL. If you can play back the macro in Excel and have it work, odds are
it'll be possible to automate it from Access.

For an introduction to automating Excel from Access, see my July, 2005
"Access Answers" column in Pinnacle Publication's "Smart Access". You can
download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html
 
Back
Top