BookmarkSubscribeRSS Feed
beamer108
Quartz | Level 8

I have created a job in Dataflux that exports output into Excel on separate tabs. Works fine when running it locally in Dataflux because my odbc has the Microsoft Office Excel driver but when I try to run it on our servers I get an error. Is there a way to get a Dataflux driver for excel installed and configured for our server?

 

1 REPLY 1
AndrewS1
SAS Employee
If you are using DMP Server 64 bit for Windows, I assume you'll need to install the Microsoft Excel 64 bit driver on your server box. If you are using DMP Server on another platform, then I believe that the Excel driver is not available. Note that SAS does not support any drivers except for the DataFlux drivers that are shipped with the product.
You might consider outputting to CSV files rather, and then pulling them all into a xlsx on separate sheets. You may be able to automate this with a vb script (outside the DMP product). I did a search on "import multiple csv files to excel sheets" and it looks like there are some solutions out there.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 855 views
  • 0 likes
  • 2 in conversation