CREATE TABLE table_6707 ("Date" TEXT, "Opponent#" TEXT, "Site" TEXT, "Result" TEXT, "Attendance" TEXT)

Who was the opponent in the game that was attended by 42,000 people?
SELECT "Opponent#" FROM table_6707 WHERE "Attendance" = '42,000'
SELECT "Opponent#" FROM "table_6707" WHERE "Attendance" = '42,000'