Using MS Access to Manipulate Excel Workbook

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
 
D

Douglas J. Steele

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 3298:More than one table exists with same name 2
ETL using MS Access 0
oracle sql plus - modified table column - not showing in Access 1
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Close specific Excel spreadsheet using VB Code in Access 1
Book Suggestions for VBA Development and Sample Databases 2
MSDE: Linked servers through ODBC 4

Top