Excel Mysql ODBC Issue

[sv1012]

I am having trouble with using certain mysql functions via the odbc connection in excel.

Query:

select name, monthname(Dob), sum(wages) from userTable group by name, month(Dob);

This query works in Mysql query browser.
But in excel when I use the odbc data connection, I loose the whole monthname(Dob) column. I tried using date_format(), but no luck

Can someone help me?

[edon]

Do you have ODBC 3.51 from mysql installed? If not this may be your problem.
Here is a video tutorial that shows you how to import mysql database data into excel step by step including installing any needed things like the odbc 3.51 driver.

http://www.youtube.com/watch?v=SxHQuK17MN4