Home » Open Source » Programming Interfaces » Calling Data from Excel
Calling Data from Excel [message #236315] Wed, 09 May 2007 09:58 Go to next message
Messages: 1
Registered: May 2007
Location: MA
Junior Member
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 #262642 is a reply to message #236315] Tue, 28 August 2007 00:04 Go to previous messageGo to next message
Messages: 18
Registered: August 2007
Location: Dhaka
Junior Member

try sql loader
Re: Calling Data from Excel [message #262667 is a reply to message #236315] Tue, 28 August 2007 01:01 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
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.


Previous Topic: Have a doubt in File handling in Perl
Next Topic: oracle and php
Goto Forum:

Current Time: Wed Aug 23 10:55:32 CDT 2017

Total time taken to generate the page: 0.13161 seconds