Re: Source of Data Files?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

As an IT person I would suggest asking your IT person for assistance.
You'll need a username and password to query the data, and they may or may
not be willing to give you "direct" access to the database.

You'll also need the Oracle client package installed on your local machine.

Tim

"ryguy7272" <ryguy7272@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B2C9E910-55A0-4E0D-BB06-4EC0E3F764FF@xxxxxxxxxxxxxxxx
Good advice! I know the Pivot Table loophole; you can probably have over
a
million rows in the database, and squeeze it into a Pivot Table as long as
the the Pivot Table doesn't exceed the 65k (approx.) limit. Then problem
is
that I can't find the ODBC connection...

If I go into Control Panel > Administrative Tools > Data Sources
(ODBC)...how do I find it in there? I don't know what the path to the DB
is.
Can I get it from the web browser...somehow?

Thanks so much,
Ryan--


--
RyGuy


"Jim Thomlinson" wrote:

Everything depends on how your database is set up. When you select
Data > Import External Data > New Database Query
You should see Oracle listed as one of the database options on the
Databases
tab. At this point you are accessing the ODBC connection to the oracle
Databases. When you do this you will probably be presented with a list of
DSN's (data server names). Now you need to know on where the tables you
want
to access live. Once you select that server you will be shown a list of
the
tables on that server. Select the appropriate table and MS Query will
open
up. You can now add other tables and criteria and such to generate the
data
set you want. The data set can be returned directly to XL or to a pivot
table. If you send the data set to a pivot table you are not limited to
65,536 records.
--
HTH...

Jim Thomlinson


"ryguy7272" wrote:

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 I'm not positive. In any event, I don't 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?
I'd
appreciate any help I can get with this. Eventually I'd 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


.

Relevant Pages

  • Re: Access and Linked tables to Oracle
    ... You might want to consider using a Pass-through query for this, ... you do not need to update your Oracle tables through Access. ... > The initial Access database was created in Access 2000. ... > is really slow if the primary key gets created on that table ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Injection Legalities
    ... I am currently writing the SANS Step-by-step guide to securing Oracle ... Oracle database, application server et al to secure it. ... >This was being discussed as a legal issue in pen-test, but I was curious if>anyone else has thought of using SQL Injection to cause a DoS. ... The second OR is>only to maintain a valid SQL statement (assuming the final character in the>query will be a single quote). ...
    (Vuln-Dev)
  • Re: Limiting Large Result Sets
    ... Oracle 9i - Database ... Using query based approach, i was able to retreive all the million rows ... Fetch Size ... rows at a time from the database cursor. ...
    (comp.lang.java.programmer)
  • Re: Source of Data Files?
    ... not be willing to give you "direct" access to the database. ... You'll also need the Oracle client package installed on your local machine. ... the the Pivot Table doesn't exceed the 65k limit. ... If you send the data set to a pivot table you are not limited to ...
    (microsoft.public.excel.programming)
  • Insert multiple records into 1 mysql table
    ... data set to insert if it is NOT the last, ... Then you build your insert query by looping through the arrays by ... INSERT INTO photo VALUES ... I have a mysql database and phtml form. ...
    (php.general)