Forum Discussion

善博 河端's avatar
善博 河端
Iron Contributor
Nov 03, 2018
Solved

How can I use Excel from SQL Server 2019 with PolyBase?

I want to know How can I use Excel from SQL Server 2019 with PolyBase? which ODBC driver string do I need to use for connecting Excel file with External Data Source? and anyone can do it? Refere...
  • 佳易 楊's avatar
    Nov 04, 2018

    Okey. 

    I am use CDATA EXCEL ODBC Driver x64..Fixed it.

    https://www.cdata.com/drivers/excel/download/odbc/

     

    Uninstall Microsoft Access Database Engine 2016 Redistributable..

    Install CDATA EXCEL ODBC Driver Version: 18.0.6817.

     

    Thanks!

Resources