Hello,
I would like to export the result of a view to a local file via stored procedure. Preferably in Excel.
All the examples I have found do not work, especially since the paths I have found save the results to the server.
I have also tried to export the results directly from Eclipse, e.g. Delimertes Textfile. But I have the problem that I have line breaks in one column and that ruins the csv file.
My goal is to have a procedure that runs automatically 2 times a day and saves the View Results to an Excel file.
Can somebody help me with this?
Thank's