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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 750 views
  • 0 likes
  • 2 in conversation