On Wed, Feb 7, 2018 at 6:36 AM, Alan Bourke alanpbourke@fastmail.fm wrote:
program. However trying to do the same from VFP, with the exact same connection string throws up a dialog looking for a data source to specified, and if you cancel that the SQLCONNECT() fails. Here's the connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=excel.xlsx;Extended Properties="Excel 12.0;HDR=YES;" Has anyone used this version successfully from VFP using the OLEDB version?
From the Install Instructions on that page:
If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:
File Type (extension) Extended Properties --------------------------------------------------------------------------------------------- Excel 97-2003 Workbook (.xls) "Excel 8.0" Excel Workbook (.xlsx) "Excel 12.0 Xml" Excel Macro-enabled workbook (.xlsm) "Excel 12.0 Macro" Excel Non-XML binary workbook (.xlsb) "Excel 12.0"
Perhaps you need to add "Xml" to the extended properties setting?