Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

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.

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

  • 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
  • From the SQL Server Start menu group, choose Import and Export Data (64-bit).

    The Import and Export Wizard starts.

  • 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
  • In the Choose a Destination dialog box, specify the SQL Server instance and database into which you want to import the Access data.
  • Complete the remainder of the Import and Export Wizard.

    • Further Information