You are using Windows 7 in 64 bits and MS Excel in 32 Bits, and you are not able to connect Excel to MysQL trought ODBC DNS 64 Bits.
Solution:
You need to create a ODBC for MySQL in 32 Bits to avoid architecture problems while connection Excel and DS over ODBC.
The Solution is full documented on the next link:
Source:
http://stackoverflow.com/questions/25039573/how-to-connect-ms-excel-2007-with-mysql