On Wed, Feb 7, 2018 at 6:36 AM, Alan Bourke <[email protected]> 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? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4tOr=fyfqxud1m2q3v1rh3xyfhcot9_wbsgtoduywl...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
