Re: Interactive Interface for Oracle ?

From: Bob Kilmer <rprgrmr_at_yahoo.com>
Date: Tue, 22 Apr 2003 02:32:59 GMT
Message-ID: <vR1pa.231852$o8.3936787@twister.tampabay.rr.com>

"RM" <richmarin_at_earthlink.net> wrote in message news:RWJna.29749$4P1.2692036_at_newsread2.prod.itd.earthlink.net...
>
>
> I need to create an application where the end user can retrieve data from
> Oracle and send the output to excel spreadsheets. Basically, I need to
> provide a user friendly graphical interface where the user can input their
> criteria's.
>
> Do you have suggestions as to sources that can tell me how to do this. Any
> books, web site etc . . .
>

Look up 'QueryTables' in the Excel VBEditor Help (AltF11, F1) or 'About importing data' in Excel Help or

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm l/xlobjQueryTables.asp

. You could start by recording a macro while creating a QueryTable, then modify and expand the VBA. You are essentially storing a query that populates a spreadsheet. You might visit microsoft.public.excel.programming if you need more advice.

And I wouldn't pay too much attention to some of the blowhards on this group.

Bob Kilmer Received on Mon Apr 21 2003 - 21:32:59 CDT