Sample Header Ad - 728x90

SQL Anywhere 12 - exporting data to Excel

0 votes
1 answer
1216 views
Do I need to install MS Office Excel on machine where is SQL Anywhere 12 server for below code to work? Or SA 12 or Windows have MS Excel Driver builtin? SELECT * FROM SalesOrders; OUTPUT USING 'Driver=Microsoft Excel Driver (*.xls); DBQ=c:\\test\\sales.xls; READONLY=0' INTO "newSalesData";
Asked by BlueMark (247 rep)
Mar 2, 2016, 08:46 PM
Last activity: Jun 19, 2022, 06:53 PM