Forum Discussion

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...

external data

PolyBase

佳易楊
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!

佳易楊

Copper Contributor

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!

善博河端

Iron Contributor

Nov 04, 2018

Nice CDATA Excel ODBC driver for connect from SQL Server 2019 to Excel file as External table.
and I hope the Microsoft ODBC driver for it, for share with friends/customers/partners.
because SQL Server 2019 build by Microsoft, Excel build by Microsoft, External table to ODBC is new feature of SQL Server 2019.