Oracle Conversion - 64bit

Part
01
of one
Part
01

Converting Data From Excel to Oracle - 64bit

To connect the Oracle database and Microsoft Excel, a user must use the ODBC connector. However, for them to connect, they must be compatible; this is, both must be 64-bit or 32-bit. Below are explicit details about converting the data.

Connecting Excel to Oracle Using ODBC Drivers


Connecting Excel to Oracle From Various Data Sources Using ODBC Drivers

  • The assumption here is that the user has already installed an ODBC driver for Oracle, which should be 64-bit in this case. Below are the steps to use when connecting Excel (64-bit) to Oracle from various data sources.

Connecting Excel to Oracle with Power Query

  • Click on "Data in Excel" > expand the "Get Data" drop-down list > select "From Other Sources" > select "From ODBC".
  • At the "From ODBC" dialog, choose the data source name (DSN). If this hasn't been configured for the ODBC driver yet, expand the "Advanced Options" dialog box and enter the connection string for the data source (without credentials, which are defined in the credential's dialog box in the next step).
  • Additionally, the user can enter an SQL statement that will be executed right after establishing a connection to the data source. After this action, click "OK."
  • When using a database username or password, the user should select "Database" and enter the credentials in the dialog box, then click Connect. However, if the database is not password-protected or there are already specified credentials in the ODBC data source settings, then select "Default" or "Custom" and press "Connect".
  • In the window that appears, the user should select the table to retrieve data from and click "Load".
  • After the above steps, the data from the table will be displayed in an Excel spreadsheet where the user can further work with it.

Connecting Excel to Oracle with Legacy Wizard

  • In Excel, the user should go to the "Data tab" > "From Other Sources" > "From Data Connection Wizard".
  • In the opened dialog box, select "ODBC DSN" and click "Next" to continue.
  • Then, select a "data source" to connect to, and click "Next".
  • To connect to the table containing the required data, select its name and click "Next" to enter and save information about the new file or click "Finish".
  • In the "Import data dialog", the user can select the way the data will be viewed in Excel and the place where to put it in the worksheet, and click OK.
  • After the above steps, the required data will now be displayed in the existing Excel worksheet.

Connecting Excel to Oracle with Query Wizard


Connecting Excel to Oracle with Microsoft Query


Connecting Excel to Oracle with PowerPivot


Research Strategy

In search of information relating to the request, the research team employed various publicly available sources, such as Devart, Support Office, and Oracle, among others. During a deep search into these websites, the team found a source, Devart, which had precompiled data on performing the actions. Additionally, we discovered that the above steps can also be used in Microsoft Excel running in 32-bit provided it's connected to the 32-bit ODBC driver.


Sources
Sources