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, [EMAIL PROTECTED] 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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
