Hi Drew, Thanks for the information. It seems quite simple and straightforward. I'll try it out.
Regards, Dave Caudle MIS Manager Lorraine Home Fashions [EMAIL PROTECTED] NOTE: Office hours are 6:00 AM - 4:30 PM (Eastern time), Monday - Thursday 704-527-8638 (Phone) 704-622-4681 (Mobile) 704-522-1891 (Fax) -----Original Message----- From: Drew Jensen [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2008 2:47 PM To: [email protected] Cc: [EMAIL PROTECTED] Subject: Re: [users] Pulling data from IBM iSeries DB2 database into OpenOffice Calc spreadsheet 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]
