can create connector but can't access most tables via Excel

I'm trying to use Excel to see mysql databases on my Linux server.  I've
created an account in mysql, I've installed the odbc driver, I've created a
new datasource on my Windows box, and now I can access one of the tables in
my database, but on all the others, I get an error: "You have an error in
your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to sue near 'paymentech'.'contacts' LIMIT 0' at
line 1" ....  but not the others ... what have I done wrong?

Here's how I created the user:

 grant all privileges on *.* to 'webdb'@'localhost'
 identified by '3402ccit';
 grant all privileges on *.* to 'webdb'@'%'
 identified by '3402ccit';

so if it works on one table, why doesn't it work on the other tables in the
same database?  What have I done wrong?

Any and all advice greatly appreciated.

Thanks.

Kenn