SQL.Request from Oracle Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2000 and have discovered SQL.Request just recently. I am trying to use it to connect to some tables to perform a standard select query in an Oracle 8.1.7 database. However, I can't find any examples specific to Oracle and my trial and error method has not been successful yet. Can anyone provide me with an example or two that have actually worked?
 
Not Oracle, but this file might be a help:
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

Recently updated to show the use of SQL.REQUEST in the same workbook.

The code is open and commented.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



CraigRhino said:
I am using Excel 2000 and have discovered SQL.Request just recently. I am
Click to expand...
trying to use it to connect to some tables to perform a standard select
query in an Oracle 8.1.7 database. However, I can't find any examples
specific to Oracle and my trial and error method has not been successful
yet. Can anyone provide me with an example or two that have actually worked?
 

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

SQL.REQUEST linking Excel to Oracle - file dsn vs system dsn? 1
sql.request 1
sql.request recalculation 1
VBA to write Excel data to Oracle table 1
Connect to Oracle using Microsoft ODBC for Oracle 2
Retrieve data from Oracle Database 1
#N/A Using SQL.REQUEST 3
sql.request 1

Back
Top