Delphi 7 Connection String for Excel 2013 Files
The connection string to load an Excel 2013 file in Delphi 7 can be:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyExcelFile.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES';
This connection string uses the Microsoft ACE OLEDB provider to connect to the Excel file, specifies the file path and name, and sets the extended properties to use the Excel 12.0 Xml format and to treat the first row as column headers (HDR=YES).
原文地址: https://www.cveoy.top/t/topic/kWzn 著作权归作者所有。请勿转载和采集!