Anyone have any ideas on how I can do this with ADO?

SQL 1: Pulls top 250 records that are not in use

  SELECT TOP 250 Id;
    FROM MyTable;
    ORDER BY Id;
    WHERE EMPTY(Used_By);
    INTO CURSOR MaxRecsCursor


SQL 2: Pulls the records that match the id's pulled above

  SELECT *, DTOC(TranDate) + " " + TranHour + ":" + TranMin AS     BkDateTime;
    FROM MyTable;
    WHERE ID IN;
    (SELECT Id FROM MaxRecsCursor);
    ORDER BY 1;
    INTO CURSOR Temp1