You are viewing limited content. For full access, please sign in.

Question

odbc for excel 2016

Updated February 28, 2018

asked on February 28, 2018

I need a workflow to add details in a table in a form to an excel spreadsheet. What are the activities that needs to be used.

I was trying to add using insert data activity. And in the data source administration wizard i used ODBC as the data source and for data source driver I have only Excel 2003, 20017/2010. But the excel in my system is 2016. How do I add excel 2016 into data source driver.

Screenshot (58).png (22.07 KB)

| Download

0 0

Replies

replied on February 28, 2018

You need to install the Excel 2016 ODBC Driver. See this for info: https://social.technet.microsoft.com/Forums/ie/en-US/dbe5fca5-c1be-4d2f-8505-467b2558086b/odbc-driver-for-excel-2016-is-missing?forum=officesetupdeploy

1 0

replied on February 28, 2018

You've picked "Direct Connections" which is listing the drivers Workflow has been tested against. You want to click back in the wizard and select "Windows ODBC" instead to get to all data sources and drivers that are installed on the machine.

As Craig mentioned, you may have to install the driver separately. Also keep in mind that on a x64 machine, Workflow is also x64 by default which expects a x64 driver for your data source.

0 0

You are not allowed to follow up in this post.

Question

Question

odbc for excel 2016

Replies

Sign in to reply to this post.