Use
http://vangelder.orcon.net.nz/ QueryEditor to get around this
limitation.
BTW a table cannot be a variabl/parametere in an SQL query so you'll
need to update the SQL statement manually for each TABLE.
Using VBA would be the best. Here is some speudo code you could use
after you created the Query manually first
DIm qtb as QueryTable
DIm strTable as String
Const Query = "Select * FROM %TABLE% where year=?"
Set qtb = Activesheet.QueryTables(1)
qtb.CommandText = Query
strTable = Inputbox("Enter a table Name")
qtb.CommandText = replace(Query,"%TABLE%",strTable)
qtb.refresh
DM Unseen