On Tuesday 20 November 2001 08:44, [EMAIL PROTECTED] wrote: > Hello Mike, > > >Sorry about the OT, but I need to export data from various MySQL tables and > >import into Excell spread sheets. Was hoping someone could suggest the > > best format, TAB, CSV..etc delimited, which is the preferred format? > > You can do this from DBI directly. You can use DBD::Excel and DBD::mysql > for directly saving the files as excel files which even works on *nix > platforms (I haven't used DBD::Excel so cant help you much on this).
There is also Spreadsheet::WriteExcel, which allows the direct creation and manipulation of Excel files. I use it a lot and it is very nifty :-) HTH Ian Barwick
