This is the driver installed via: https://www.microsoft.com/en-us/download/details.aspx?id=54920, Microsoft Access Database Engine 2016 Redistributable. It installs the ACE 12 OLEDB and ODBC drivers so you can (for example) query Excel sheets using SQL into a VFP cursor. I've been using the 2010 version for years. This version isn't playing ball with VFP however. It appears to be installed correctly because I can pull data out of a sheet from a C# 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?
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---