I have script which uploads a xls document and inserts them into an access database by asp.
I select the records from the xls document with the statement:
set ExcelRS = ExcelConn.Execute ("SELECT FirstName, LastName, EmailAddress, HomeCountry, Company FROM Contacts")
This works fine if the sheet is called Contacts. But crashes if it is not. Is it possible to find out the sheet name when the file is uploaded.