Question Re: Exporting data to Excel in Technology Q&A

Exporting data to Excel

Former Member — Wed, 02 Mar 2016 14:21:06 GMT

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

Re: Exporting data to Excel

Former Member — Wed, 02 Mar 2016 16:33:28 GMT

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.

Re: Exporting data to Excel

VolkerBarth — Thu, 03 Mar 2016 04:02:31 GMT

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...

Re: Exporting data to Excel

Former Member — Thu, 03 Mar 2016 08:59:04 GMT

-- 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.

Re: Exporting data to Excel

VolkerBarth — Thu, 03 Mar 2016 09:09:59 GMT

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:)