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

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.


.