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

On Fri, 2008-03-07 at 08:01 -0600, Kenn Murrah wrote:

> I'm trying to use Excel to see mysql databases on my Linux server.

Hmmmmmm ... Excel isn't exactly the best tool for the job ( take our
current example ). Are you planning on using Excel to manipulate the
data, or are you just using 'whatever is available' to view data?

> 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?

You didn't really describe how you got to this point. Do you have the
entire SQL that Excel is sending? Are you using Excel's 'query builder'?

> 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?

It's not a permission problem. It's an SQL problem, as the error above
indicates.

Personally I avoid Excel like the plague. If you just want to see / edit
data, try MySQL's query browser & administrator products. What are you
trying to do with your data?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2
9922 7989
email: [email protected]
website:
http://www.nusconsulting.com.au



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]