Query problem on table named 'resource'

[phoenix_me]

I can't execute query which is 100% right. It is accepted in different
programs but not in excel (Microsoft Query)
The Query is:

select * from PUB.Resource

I think that the problem is because table name is Resource, and this
is reserved word either in SQL '92 or Progress Database. Any hint how
to get data from this table? Any special signs as [ ], ( ), " ", ' ', ?

 

[phoenix_me]

I can't execute query which is 100% right. It is accepted in different
programs but not in excel (Microsoft Query)
The Query is:

select * from PUB.Resource

I think that the problem is because table name is Resource, and this
is reserved word either in SQL '92 or Progress Database. Any hint how
to get data from this table? Any special signs as [ ], ( ), " ", ' ', ?

I found answer myself. It's need to use aliases together with "".
So query should look like:

select * from PUB."Resource" as my_alias