Dim rsSet strSQL = "SELECT * FROM set_query" Set rsSet = Server.CreateObject("ADODB.Recordset") rsSet.Open strSQL, objConn Now this gets all the info out of a query but I to get the info straight out of the table.