>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 + [;";])
>

Craig's Boyd program worked for me, but out of all cases for me it used the last case only. I have Windows 7 64 bit and I Office 2010 64 bit, but still ACE.OleDB.12 didn't work for me.