> -----Original Message-----
> From: Ian Barwick [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 25, 2001 2:40 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Exporting format
>
>
> 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
Hmmm. How do you directly save files from MySQL to Excel using these two
modules?
> > 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
