Exporting data to Excel

[Former Member]

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

[Former Member · Accepted solution]

Yes you do. You will need the ODBC driver for Excell to make that work. SQL Anywhere does not install that driver for you.

You may have a Excel ODBC driver available without having Excel itself being installed but that would only happen if it was installed as part of some other software.

As an alternative approach, version 17 of dbisql supports direct output to the format Excel; which also requires the driver.

[VolkerBarth · Accepted solution]

As an alternative approach, version 17 of dbisql supports direct output to the format Excel; which also requires the driver.

Is that a new feature? - I have not noticed that in the "What's new" section and thought it is the old "Excel 2.1(?)"-compatible format which was somewhat restricted - see that older discussion.

If v17 has something new there, I would like to give that a try...

[Former Member · Accepted solution]

-- Is that a new feature?

Yes it is. In fact there are a few enhancments around it.

-- If v17 has something new there, I would like to give that a try...

Go ahead and see what you think.

While at it's most basic functionality it is a syntactical enhancement to DBISQL's FORMAT options for INPUT and OUTPUT statements (with reintroducing the EXCEL format option) but also with an understanding of worksheets. And those are also reflected in the IMPORT/EXPORT wizard as well.

[VolkerBarth · Accepted solution]

Yes it is. In fact there are a few enhancments around it.

Ah, thanks for the pointer... - I still find it more difficult to fully read through the v17 "What's New" sections than to those of older versions, so that's why I have learnt to state "I have not noticed that in ..." instead of a stronger "It's not mentioned in..." claim. Humility is a virtue, of course, and if v17 helps me to improve in that respect, it's welcome:)