cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting data to Excel

Former Member
0 Kudos
2,506

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

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
Contributor
0 Kudos

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
0 Kudos

-- 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
Contributor
0 Kudos

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

Answers (0)