From the Internet to find the answer:
The original connection Provider=Microsoft. Jet. The OLEDB. 4.0; The Data Source=1. XLS; Extended Properties="Excel 8.0; HDR=YES; IMEX=1
"
Is amended as:

The Provider=Microsoft. ACE. The OLEDB. 12.0; The Data Source=1. XLS; Extended Properties="Excel 12.0; HDR=YES; IMEX=1
"

But I don't know how to find the link, with which the master help!

CodePudding user response:

First need to install the new version of EXCEL

CodePudding user response:

Install the new version of EXCEL