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 --- _______________________________________________ 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/1518003364.3179585.1262528824.3180c...@webmail.messagingengine.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.
