dyerc
December 14th, 1999, 08:52 AM
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?