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: 68454
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: JDBC Driver does not insert Euro Symbol correctly
Next Topic: Latest JDBC driver throws strange error while querying LONG
Goto Forum:

Current Time: Sun Jun 04 09:44:47 CDT 2023