Access97 table with a dash in it's name [RESOLVED]

Hi all,

I am stuck with an old Access97 table (SO-Entry) and working with VB6. I am trying to open an ADO connection and get an error.

strSQL = "select * from so-entry order by bill_co"
rsSOEntry.Open strSQL, cnSales, adOpenForwardOnly, adLockOptimistic
(I'll dump the select * when I get this working)

I receive a 'run time error -2147217900, syntax error in from clause'.

This must be caused by the dash that's in the table name SO-Entry because I can open all other tables in the database.

Any idea on how to get this to open? I'm not allowed to change the table name.

tia,

Use [] around name

Code:

---

strSQL = "select * from [so-entry] order by bill_co"

---

Many thanks Andrey!

It must be Friday 'cause I knew that.:)