Help with large Data move

[GaryMazzone]

I am trying to move data from Oracle to Excel. I can do this but I'm having a real issue with the amount of data. In one example I need to move 80950 records from the database into Excel and perform graphing functions. I know that the size it too large for one Worksheet so I set it up to split the data into a second worksheet if the is more the 60,000 records to move. (The spilt will start tracking records again once the new sheet is started.)

I can move the data but it takes forever to perform. Is there any better way of posting this data with out moving column to column for each row in the dataset?

[FishGuy]

Does Oracle not have the equivelant of MS SQL Server DTS.

[sevenhalo]

Just a suggestion, take it or leave it, but...

Couldn't you allow for your app to handle all of the data, do summing and everything else that the exce; sheet would do? I don't know your requirements for this (if the excel sheet has to be able to change values on itself), but if you're able to just pass the totals to the excel sheet; it might cut down on time and effort immensely.

Like I said, I don't know the project specs; but if it is just a graph, you might want to consider it?

[GaryMazzone]

I have to graph the stored data in two series the Pressure in the well (this releates to the depth of the water in the well) and the Temperature of the water in the well at the time (date and time) the sample was taken. The X-axis is the Date/Time and the two series are ploted on the Y-axis.

There is nothing like DTS in Oracle (at least I don;t think so).


I can get all the records with out a problem. An I can post to Excel just really slow.