| Calling Data from Excel [message #236315] |
Wed, 09 May 2007 09:58  |
stuartm
Messages: 1
Registered: May 2007
Location: MA
|
Junior Member |
|
|
Hello,
I want to make a call from SQL to a spreadsheet, capture the data from a particular cell and then return the value back to SQL for subsequent use. I have been searching the net and I see mentions of ODBC and ADO, calling SQL from Excel, etc. but nothing explicit. I am doing this from Oracle DB. Thanks.
|
|
|
|
|
|
| Re: Calling Data from Excel [message #262667 is a reply to message #236315] |
Tue, 28 August 2007 01:01  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Yes, you can use ODBC (or ADO), this is not specific to Oracle you can do it for any database for which you can have an ODBC driver.
You have to use VBA (Visual Basic for Application, the programming language in Microsoft applications) to do this.
I think you should better post your question in a Microsoft forum to get an answer about VBA code.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
