what is connection string to load excel 2013 file in delphi 7
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/dyma 著作权归作者所有。请勿转载和采集!