At some point you must know what the table name is in order to be able to load from it?
You can use a variable in your load statement like this:
SQL SELECT *
You could then have an input box on the screen to allow the user to input the table name before refreshing?
If the user does not know the table name, but you know the database it is in you could perhaps get a list of tables in the database (perhaps doing a select on SysObjects (in SQL Server) or by using the SQLTABLES command (for ODBC connections) and then use a PEEK statement to get the table name from that query into a variable before performing a load as above.
If you could elaborate on how you would envisage the table name should be derived or captured then I can give further advice on how to achieve that.
The file name will be known, but the the table name is unknown....Sheet1 will not always be named Sheet1 and I will not be able to predict the table name because it is a randomly generated long set up letters and numbers by an external source.