Delphi 7 Connection String for Excel 2016 Files

The connection string to load an Excel 2016 file in Delphi 7 is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\to\file.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES';

Note: You need to have Microsoft Access Database Engine 2016 Redistributable installed on your system to use this connection string.