I am getting a syntax error in the FROM clause error and for the life of me I cannot see what is wrong with my SQL string. Here it is:

SQLStmt = "SELECT " & strTableName & ".* INTO [CLEARANCE] FROM " & strTableName




strTableName is the name of a table that I extracted from TableDef earlier in the module. Am I blind? :-)