View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
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