Any idea on how I could access a sheet in Excel 2.1 using OLEDB?

Most queries look like this with more recent version of excel:

SELECT * FROM [Sheet Name$]

What happens when there are no sheets as in the case of older excel
versions?