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?
asked 02 Mar '16, 14:21
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.
answered 02 Mar '16, 16:33
Nick Elson S...