OT:converting csv to xls with Rev

[Luis]

Hiya,

MSSQL (needs MS Jet and MDAC) has 'Data Transformation Services'  
which will guide you through exporting directly from MSSQL to Excel.
You can create a DTS Package with the DTS Export Wizard, and not just  
to Excel. I haven't created any packages but I assume you could call  
them up from Rev or as a scheduled task.

Cheers,

Luis.


On 9 Jan 2008, at 13:08, runrev260805 at m-r-d.de wrote:

> Hi,
>
> does anyone know a way to convert a csv to xls with Rev under Windows?
> MS Excel is installed on the machine, where the app should run.
>
> In my Rev app i connect to a MS SQL server and get data from it.  
> This data is
> stored in a csv file on harddisk. But i also need a xls version of  
> that data.
>
> At the moment i am using a 3rd party program, which i run from Rev  
> with command line switches.
>
> But i want to solve this completely with Rev. I assume, that i will  
> need vbs for this under windows.
> But i do not know enough about vbs.
>
> Regards,
>
> Matthias
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>