Is it possible to connect to an OLEDB provider using ODBC? I always assumed that required ADO, but I found the code below in Craig Boyd's AppendXLSX.prg. Unfortunately, it pops up a dialog for me to select a data source, so I'm curious if this would have worked for Craig or anyone else.
m.lnSQL = SQLSTRINGCONNECT([Provider=Microsoft.ACE.OLEDB.12.0;Data Source="] + m.tcXLSFile + [";Extended Properties="Excel 12.0 Xml;HDR=] + m.lcHeaderRow + [;";])