Excel 2016 - What is the connection string for - Microsoft Community

the following connection works in 2007.

with cn1
    .provider = "microsoft.ace.oledb.12.0"
    .connectionstring = "data source=" & strfile & ";" & _
    "extended properties=""excel 12.0 xml;hdr=no;imex=1;readonly=true"""
end with

strsq1 = "select * [xxxxsheet$" & rng & "];" rng excel range exceeds 65536.

what connection string 2016 office 365 excel. below code not works me in 2016

with cn1
    .provider = "microsoft.ace.oledb.16.0"
    .connectionstring = "data source=" & strfile & ";" & _
    "extended properties=""excel 16.0 xml;hdr=no;imex=1;readonly=true"""
end with

strsq1 = "select * [xxxxsheet$" & rng & "];" rng excel range exceeds 65536.

if provide instead of excel16.0 excel12.0 connection string executes sql throws error. if provided excel 16.0 connection throws error. please me correct connection string 2016 excel.

use same string office 2007 string work versions present.

Microsoft Education / Microsoft Classroom (Preview)