We may be in "violent agreement" here... Here's what I see: Step 1) Get data out of the database. Either straight JDBC or Borland's query dataset or whatever can do this job. Pure java, no problemo... I think we're agreeing here.
Step 2) Shove data into Excel. Use POI/HSSF to do it (pure Java, no problemo) OR use JDBC/ODBC to talk to Excel's ODBC. This option is definitely Windows specific/non-portable. Bottom line - without POI or an expensive alternative, life sucks for step 2! I think that I was looking at JDBC for Step 1, while you were thinking about it for Step 2??? Just a guess. We likely agree on things otherwise. Regards, Jeff -----Original Message----- From: Andrew C. Oliver [mailto:acoliver@;apache.org] Sent: Sunday, November 03, 2002 10:51 AM To: POI Users List Subject: RE: Using Borland's QueryDataSet to send to Excel Okay, so how would JDBC work otherwise? Maybe thats what I'm missing.. I'm quite interested in that. On Sun, 2002-11-03 at 12:40, Jeff Blackwell wrote: > That's what I'd use POI/HSSF for... to build the Excel stuff in Java. > Maybe I'm off base, but I think that's probably what he did... Again, it's > all Monday morning quarterbacking... If he were going ODBC , what you're > saying makes sense. > > Regards, > Jeff > > -----Original Message----- > From: Andrew C. Oliver [mailto:acoliver@;apache.org] > Sent: Sunday, November 03, 2002 9:00 AM > To: poi users > Subject: RE: Using Borland's QueryDataSet to send to Excel > > > 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> > > > -- > 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> -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
