Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked Files (Source and Dependent files) | Links and Linking in Excel | |||
moving pivot table data source files | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
recovering chart source data from deleted files | Excel Discussion (Misc queries) | |||
How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) |