Re: export to

2005-02-16 Thread Jonathan Leffler
file in another db2 database. > > Here is what I try: > $dbh->do(q{export to test.ixf of ixf select * from > steph_test}) or die $dbh->errstr; > > But this give an error: > DBD::DB2::db do failed: [IBM][CLI Driver][DB2/NT] > SQL0104N An unexpected token "test&qu

export to

2005-02-16 Thread Stephane Legault
Hi, I'am using DBI::DB2 for a lot of program and now I need to create a programme to archive data. So, I would like to export data from database to a file and then load that file in another db2 database. Here is what I try: $dbh->do(q{export to test.ixf of ixf select * from steph_test}

Re: module/function to export to Excel?

2002-07-23 Thread Bart Lateur
On Tue, 23 Jul 2002 02:53:45 -0400, Nick Hoffman [UWO] wrote: >Hiya. I'm using DBD::ODBC and an Access2000 database. Is there a module or >function that can export an Access2000 database to an Excel spreadsheet? If >so, would someone mind pointing me in the right direction? FWIW, Spreadsheet::Wr

Re: module/function to export to Excel?

2002-07-22 Thread Paul Busse
Hi, we use DBIx::Copy and DBD::CSV( or was it DBD::Text) Apperently there is a DBD::Excel as well Regards Paul - Original Message - From: "Nick Hoffman [UWO]" <[EMAIL PROTECTED]> To: "DBI-Users" <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 08:53 Su

module/function to export to Excel?

2002-07-22 Thread Nick Hoffman [UWO]
Hiya. I'm using DBD::ODBC and an Access2000 database. Is there a module or function that can export an Access2000 database to an Excel spreadsheet? If so, would someone mind pointing me in the right direction? Thanks! Nick Hoffman