Talking to an MS Access table w/bad name

[gjlowe]

I am having difficulty pulling data out of a poorly named table in MS Access. The original author named on of the tables in the Access database "pulldown-system" in order to denote that it was a pulldown field in a form. Now, I have built a PHP interface to this database, but cannot pull data from the tables that have names like this (with hyphens in them). When I try to query that table, I receive an SQL syntax error. How can I solve this problem?

[Anon]

maybe duplicate the table to pulldown_system and gradually switch all code to use the newer table and discontinue the pulldown-system table.

[Anon]

Access support this syntax:

select * from [pulldown-system]

[gjlowe]

Thank you VERY much! This is exactly the answer!