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
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 #262642 is a reply to message #236315] Tue, 28 August 2007 00:04 Go to previous messageGo to next message
hasan_uiu
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: 68624
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.

Regards
Michel

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: Thu Mar 28 03:58:02 CDT 2024