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.
- 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.
- 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.