[mdb-dev] mdb-sql - problem with "_" in table name

[Radek <rad...@ce...>]

Hi all,
I have MSAccess database with tables which contain the "_" char in name.

When I try run following commands I get an error.
echo "Select * from Alloc_NSE_TNE" | mdb-sql test.mdb   ...  error: Error at line : syntax error near _   Couldn't parse SQL
echo "Select * from 'Alloc_NSE_TNE'" | mdb-sql test.mdb   ...  error: Error at line : syntax error near Alloc_NSE_TNE   Couldn't parse SQL
and another command with the similar syntax are wrong.

But when I write  echo "Select * from Test" | mdb-sql test.mdb  command is OK. (In table name is not "_" char)

Please help, how write commands with "_" in table name.

Thanks
Radek