I have a worksheet that obtains its data from an Access database. I am
trying to convert from DAO to ADO but am now getting errors when tring to
open a recordset that worked perfectly well in DAO. I am using
TRANSFORM.....SELECT in the SQL to open the recordset, can I do this using
ADO?
TIA
Mark