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: 2,836
Default Source of Data Files?

I am trying to find the source of a specific data file...

I often use an Oracle DB, which is accessible via a web browser. After
logging into the DB, I can make a few selections for the specific data sets
that I want to view, or I can see a saved data set. Anyway, all of this is
ok, but I was hoping to find a more direct way of accessing the data that I
need (probably the saved data set). By clicking on Data Import External
Data New Database Query, I can see tabs that read Databases, Queries, and
OLAP Cubes. I am pretty sure Databases will give me access to this Oracle
DB, but Im not positive. In any event, I dont know where to search for the
Database once I click the €˜Browse button. Is there a way to see the source
of the Oracle BD, which now is only viewable through the web browser? Id
appreciate any help I can get with this. Eventually Id like to record a
small macro to have the import done automatically, once the link between
Excel and Oracle is established.

Thanks for the assistance!!
Ryan--



--
RyGuy
 
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
Linked Files (Source and Dependent files) midcastro Links and Linking in Excel 0 February 19th 11 04:16 PM
moving pivot table data source files Will C. Excel Discussion (Misc queries) 2 June 5th 06 11:48 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM
recovering chart source data from deleted files [email protected] Excel Discussion (Misc queries) 1 August 30th 05 12:53 AM
How can i set the source-data-range of pivottable2 to the source . Piet Excel Discussion (Misc queries) 0 March 5th 05 09:31 PM


All times are GMT +1. The time now is 08:18 PM.

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

About Us

"It's about Microsoft Excel"