0

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";

1 Answer 1

1

The OUTPUT USING format of the statement is using a ODBC driver to create/send the data to.

This means you must have a ODBC driver on the server which can create XLS files.

There is a MS Office 2007 ODBC download available from microsoft which provides such a driver.

I don't know if there exist 64-Bit drivers (I think it must match with your dbserver 32/64bit) nor if Office 2010/2013/2016 ODBC drivers exist.

Docu output-statement

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.