>You need Two Record Sets. Each Query is an independent operation. You are >overwriting the first query results with the second. The RecordSet object has a method called NextRecordSet, so you won't need two recordsets. To get more than one recordset at a time, open it using semicolon, like this: Set rs = conn.execute "Select * from pubs; Select * from news" You can check for more information on msdn: http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthnextrec.asp /Paulo Guedes