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 02 Mar '16, 14:21

BlueMark's gravatar image

BlueMark
24691523
accept rate: 50%


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.

permanent link

answered 02 Mar '16, 16:33

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 31%

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

(03 Mar '16, 04:02) Volker Barth

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

(03 Mar '16, 08:59) Nick Elson S...
Replies hidden

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

(03 Mar '16, 09:09) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×412
×25
×13
×8

question asked: 02 Mar '16, 14:21

question was seen: 310 times

last updated: 03 Mar '16, 09:09