I installed the hadoop ODBC 64bit driver and TEST was successful but when I try to use it in Excel 2013 on 64bit win 7 I get the following error:
the specified DSN contains an architecture mismatch between the Driver and Application
If your driver is 64 bit and win 7 is also 64 bit as you say, then that leaves your excel. Check in your task manager process tab if it shows anything that says your excel is 32 bit? If it is, then you probably need a 32 bit driver.