Can I can connect a 64-bit application to a 32-bit ODBC driver?

Yes, you can connect a 64-bit application to a 32-bit ODBC driver by using the 64-bit Windows ODBC-ODBC Bridge distribution.

  1. Download the 64-bit ODBC-ODBC Bridge for your application platform.

    Accept the Default option during Setup, which installs both the ODBC-ODBC Bridge client and server components.

  2. In the 64-bit ODBC Data Source Administrator, configure an ODBC-ODBC Bridge client data source that points to the Access ODBC driver data source.

    To access the 64-bit ODBC Data Source Administrator, enter the following command in the Windows Run dialog box:

    odbcad32.exe
  3. From the SQL Server Start menu group, choose Import and Export Data (64-bit).

    The Import and Export Wizard starts.

  4. Complete the Choose a Data Source dialog box:
    Setting Value
    Data source .Net Framework Data Provider for ODBC
    Dsn The name of your ODBC-ODBC Bridge client data source.
    Driver Easysoft ODBC-ODBC Bridge
  5. In the Choose a Destination dialog box, specify the SQL Server instance and database into which you want to import the Access data.
  6. Complete the remainder of the Import and Export Wizard.

Further Information