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.

Am I missing something?

strSQL = "SELECT * FROM TableName"

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