Does the JDBC stuff not have to go through ODBC to get to Excel? And does not the ODBC driver require Excel native binaries?
-Andy On Sun, 2002-11-03 at 00:55, Jeff Blackwell wrote: > Maybe I'm missing something... The QueryDataSet that he's referring to > should be pure Java, no? Why wouldn't it work on Linux? Maybe you were > thinking of their Delphi components or something? IIRC, the stuff he's > referring to are just Java wrappings around JDBC. They just make it easier > to bind screen controls to a DB. With Swing, that's usually a bad idea, so > they don't get used a lot, in my experience. They should be portable, but > are no doubt slower, due to the extra goo involved. I still prefer to use > straight old JDBC myself. No biggie... > > Have a good weekend! > > -Jeff > > -----Original Message----- > From: Andrew C. Oliver [mailto:acoliver@;apache.org] > Sent: Saturday, November 02, 2002 1:12 PM > To: POI Users List > Subject: Re: Using Borland's QueryDataSet to send to Excel > > > ;-) But it doesn't work too well on my linux box ;-) > > Jeff Blackwell wrote: > > >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> > > > > > > > > > > > > -- > 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> > -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
