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
Last activity: Jun 19, 2022, 06:53 PM