Without getting into any religious debate here, either straight JDBC or the Borland stuff should work about the same. No control needs to be written. Both effective open a "dataset" and allow you to walk the structure. What you're planning to do is shove the data row by row to the HSSF structure, no? My personal preference is plain old JDBC calls. The Borland wrapper components are used much more for "bound" interface work. Based on that I would think that straight JDBC would be slightly faster, if there is a difference. That said, either way should work.
Kind regards, Jeff -----Original Message----- From: news [mailto:news@;main.gmane.org]On Behalf Of Peter Boivin Sent: Wednesday, October 30, 2002 7:43 AM To: [EMAIL PROTECTED] Subject: Re: Using Borland's QueryDataSet to send to Excel Let me ask you this then. If I don't use the borland approach, what is your preferred way of getting stuff from a database and pushing it to excel? "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote in message news:3DBFECB2.4070104@;apache.org... > You'd have to write an appropriate control I'd assume. > Though, Its been years since I messed with Borland's weird > data control stuff...I hope for your sake its better now ;-) > > -andy > > Peter Boivin wrote: > > >If any of you are familar with queryDataSet by Borland (using JBuilder 7), > >could you give me some kind of clue as how to push that over to excel using > >Poi? > > > >I have an object of queryDataSet all set. I just don't know how to push > >over to excel. > > > >Kindly, > >Peter > > > > > > > > > > > >-- > >To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> > >For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> > > > > > > > > -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
