Worksheet names can be used as table names by specifying the sheet name followed by a '$' sign. For example, type "Sheet1$" to indicate that Sheet1 is the table to be linked.

The Microsoft Excel driver does not return a list of sheet names for users to choose from.