Gordon Dexter on 3 Jul 2008 06:54:10 -0700


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] Text file to Excel, automated


Easiest way I can think of would be to just make a CSV file.  Excel will 
happily read that, and it's plain text so it's a cinch for a script to 
make.  You can send the CSV file out unconverted, and they will barely 
notice the difference.

--Gordon

Julien Mills wrote:
> Hi all,
>
> I'm looking for a way to put the text output of some
> sql queries into an excel document which I can email
> to others in the company.
>
> What I do now is run the query, import it into OO, 
> save it as an excel document and then email it.
>
> I'd like to automate the whole process.  I believe
> I can create a .slk file and then excel will read
> that.  Anyone have any experience doing that or is
> there a niftier way to do it?
>
> Thanks,
>
> ------------------------------------------------------
> Julien Mills                    julienfmills@yahoo.com
>
>
>       
> ___________________________________________________________________________
> Philadelphia Linux Users Group         --        http://www.phillylinux.org
> Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
> General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug
>   

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug