Re: Oracle to Excel Export - Lots of records need speed

Hi,

It is just a matter of seconds. You could try a trail version of it if you
download from my site. I have clients who generate about 250M of output in
about 1 min 30 seconds.

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Hyperactive" <Hyperactive@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:622EAB36-5F80-428F-9BF7-5E69D7F2ED83@xxxxxxxxxxxxxxxx
> Can you provide more information on performance? How fast could it do
> 30,000
> records? The fields must be written to excel into fields that are
> formatted
> as TEXT.
>
> "Val Mazur (MVP)" wrote:
>
>> Hi,
>>
>> You could try my component that was designed specifically for this. Check
>> it
>> on a Web site
>>
>> --
>> Val Mazur
>> Microsoft MVP
>>
>> http://xport.mvps.org
>>
>>
>>
>> "Hyperactive" <Hyperactive@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:D8BC5531-778B-489F-883F-808F1BB290F4@xxxxxxxxxxxxxxxx
>> >I am trying to export some large queries in a VB.NET app (NOT an asp.net
>> >web
>> > app). The queries are coming from an Oracle database and can contain
>> > anywhere
>> > from 30,000 - 60,000 records that need to go into an Excel spread***.
>> >
>> > I have tried the automation with writing out rows and columns, and I
>> > have
>> > also tried using the web datagrid writing out. All these options are
>> > severely
>> > slow. Does anyone have any code snippets or can anyone direct me to how
>> > i
>> > can
>> > make this export fast? The export needs to be compatible with EXCEL 97
>> > and
>> > ABOVE, which is making this more difficult since I cannot just export
>> > directly to xml format or something simple. I even tried exporting to
>> > XML
>> > then using automation to open the file and do a save as, but Excel
>> > trying
>> > to
>> > just open the XML file was taking forever.
>> >
>> > Any help would greatly be appreciated.
>>
>>
>>


.