Dave Caudle wrote:
I am considering installing OpenOffice and have a question. With iSeries
Access, IBM provides an add-in data transfer tool to install with MS Excel
<snip
explain this technology to me? Perhaps it would provide the same
functionality as the data transfer tool I'm familiar with.
Under OpenOffice.org 2.x the functionality you require is provided by
the Base module.
Using Base you would create a connection to your DB2 database with any
of the following connectors:
ODBC
OLE DB
JDBC
( IBM offers all of these types of drivers for the DB2 database package.)
You can find specific information about the ODBC driver at this location:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.cli.doc/doc/c0007944.htm
Once this datasource is defined using Base then it is a simple process
to link - or - import the data into a Calc file.
Specifics for setting up a link to the data can found in this posts at
the web based Community Forum
http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=3857 (
Copying table to spreadsheet )
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
