LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 504
Default Running Queries to Oracle from Excel 2000

Greetings! I have a number of ODBC queries in Access that I run against an
Oracle database. I later use the result set in Excel. I would like to run
these queries directly from Excel and save the whole Access step so that the
process is more seamless for my enduser.

Would someone please point me to some primer on this kind of data access
programming in Excel VBA. I'm very familiar with VBA, but this is new
territory for me and I need a good place to start. I have several books that
I have consulted, but I need something more specific to what I am trying to
do.

Thanks in advance!
--
Kevin
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open all Excel spreadsheets/fles before running queries Fredrik Excel Discussion (Misc queries) 0 April 30th 10 11:01 AM
Running Access queries from Excel smartchick Excel Programming 4 January 3rd 05 11:23 AM
External Queries - Excel 2000 MK Excel Programming 0 September 23rd 04 08:55 PM
Running MS Queries keepITcool Excel Programming 1 July 15th 04 09:42 AM
Editing Queries in Excel 2000 Ravi Excel Programming 2 February 11th 04 09:44 AM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"