>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?