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

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.
>
>
>
.