You don't specify how you transfer data, but if you're using SQL Server Import and Export Wizard you need a 32 bit ODBC-driver.

There's two ODBC Administrators:

32 bit %windir%\syswow64\odbcad32.exe

64 bit %windir%\system32\odbcad32.exe

General rule:

32 bit software uses 32 bit (ODBC-)drivers

64 bit software uses 64 bit (ODBC-)drivers