Tuesday, November 07, 2017

Issue Accessing Microsoft Excel Spreadsheets

A Windows update on October 10, 2017 caused the Microsoft Excel ODBC driver (specifically, the “Microsoft Excel Driver (*.xls)” driver) to stop working correctly. Many of our customers use the ODBC driver to report on Excel data in Stonefield Query, including combining data stored in Excel with data stored in traditional databases such as Microsoft SQL Server in a single report, something Stonefield Query can easily do.

The solution is to use the “Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)” driver instead. However, this requires installing the latest Microsoft Access Database Engine components, which you can download from https://www.microsoft.com/en-ca/download/details.aspx?id=13255.

Friday, November 03, 2017

2017 VFPX Administrators’ Award

Congratulations to Greg Green for being awarded the 2017 VFPX Administrators’ Award at Southwest Fox 2017. He was awarded this for his work on the VFPXWorkbookXLSX project, a tool that allows VFP developers to read from and write to Excel XLSX files quickly and easily without needing Excel installed. I’ve used VFPXWookbookXLSX for several years and can attest to it usefulness.