Urgent Help?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Urgent Help?

  1. #1
    Join Date
    May 2000
    Location
    OHIO
    Posts
    20

    Wink

    I am using Excel to connect to Oracle Database and retrive rows, but, In excel it does not go over 65,000 rows, is there way I call tell excel go to the next sheet,

    Rahul Khana

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi
    Just spool the output from sqlplus into a file, then try opening from excel. I havent tried this before.Hope it works.

  3. #3
    Join Date
    Sep 2000
    Posts
    7

    you will get the same result - over limits.

    use editor to cut spool file to small file first.
    XDBA

  4. #4
    Join Date
    Oct 2000
    Posts
    26

    Alternative Method....

    I do a lot of data conversion and this is always a problem....I put it into MS Access first, and then run a query to make smaller tables then drop it into excel....just an idea..

    John

  5. #5
    Join Date
    May 2000
    Location
    OHIO
    Posts
    20

    Help

    This doesn't make sence, if I spool it I will have the same problem, But If I take in to Access and run a query against
    How would that help me up the data in to a spread sheet
    does acess have spread sheet?

    SO I dowolad a table to Access, then how do I run a query again's that table?


    Thanks
    Rahul Khana

  6. #6
    Join Date
    Oct 2000
    Posts
    26

    Access instructions...

    You load the data into access just like you would excel. During improt, access gives you the option to add a primary key column whihc is just a seuqetial lisyt of numbers. do that.

    Then run a 'make-table" query fromt he acceess query wizard, and use your select criteria where PK < 60,000.

    that is table 1. then do it agin to table 2, criteria > 60,000 and < 120,000. repeat as nessecary.

    then you can expoirt the access tables as an .xls file and you are all set :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width