Vb6 Enterprise/Excel97/Ado I need to access the third worksheet in an Excel file. "SELECT * FROM [PVM_AXIS!A1:E38]" gives a syntax error but without "PVM_AXIS" provides access to the first worksheet. What is the syntax to access a specific non-first worksheet?
