In windows 7 : The specified DSN Contains an architecture mismatch between the Driver and Application

ODBC Driver setup

The following steps show how to access a 32-bit ODBC driver from a 64-bit application on a 64-bit Windows machine. The ODBC driver used is the Microsoft Access ODBC driver. The application used is the SQL Server Integration Services (SSIS) Import and Export Wizard.

1. In the 32-bit ODBC Data Source Administrator, configure a System data source for the Access ODBC driver. To access the 32-bit ODBC Data Source Administrator, run the following command in the Windows Run dialog box:
   

   %windir%\syswow64\odbcad32.exe