Andy and Jeff, Thanks for your assistance. I was able to get the database info dumped into an excel file and well formatted.
"Jeff Blackwell" <[EMAIL PROTECTED]> wrote in message news:JBENKKCBIOPDLCNMFHNKGEHPCBAA.jblackwell@;tenacityinc.com... > 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>
