getting info from a table, not a query

[bloody_football]

Dim rsSet
  strSQL = "SELECT * FROM set_query" 
  Set rsSet = Server.CreateObject("ADODB.Recordset")
  rsSet.Open strSQL, objConn

Now this gets all the info out of a query but I to get the info straight out of the table.

 

[pbaldy]

Am I missing something?

strSQL = "SELECT * FROM TableName"

 

[bloody_football]

strSQL = "SELECT * FROM TableName"
gives me a 'Syntax error in FROM clause. '
The table name is 'set' so it is definately not a spelling error

James