When importing an Excel sheet into a dataset, there is a command like this:

Select * From [Sheet1$]

to grab all the rows.

However, this is good as long as we know the workbook name. Is there a way to detect the workbook name so we can have this generic?