Save Big on Cyber Monday! Up to 40% Off
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

Connect DBxtra to Microsoft Excel Online and access data

Accessing a Microsoft Excel Online database can be fast and seamless with an Open Database Connectivity (ODBC) solution. Devart ODBC Driver for Microsoft Excel Online provides full interoperability and allows you to access live Microsoft Excel Online data. The driver enables you to retrieve, view, and modify Microsoft Excel Online data directly within DBxtra.

Step 1. Create a new ODBC connection

Select or create a project in DBxtra. Then, on the Home tab, select Data Connection > ODBC Connection.

DBxtra Designer with the expanded Data Connection submenu.

Step 2. Name the connection

In the Connection name field, enter a name for the connection. Next, click the Ellipsis (...) ellipsis button to start selecting a data source.

The Connect through ODBC dialog with filled out Connection name.

Step 3. Select the provider type

On the Provider tab, select Microsoft OLE DB Provider for ODBC Drivers, then click Next.

The Data Link Properties dialog with the opened Provider tab.

Step 4. Select your DSN

Under Use data source name, select your DSN. You can also select the catalog that you want to use under Enter the initial catalog to use. To verify the connection settings, click Test Connection. Then click OK to save the data source settings.

The Data Link Properties dialog with the opened Connection tab.

Step 5. Set the SQL dialect and user access

In SQL dialect, select ANSI SQL/2003. Under Select User Groups who can view this Connection, select the needed options.

The Connect through ODBC dialog with filled out fields.

Step 6. Save and view the connection

Click Ok to save the connection. The connection appears in Project Explorer under Data Connections.

Project Explorer with the expanded Data Connections subfolder containing a new connection.

Step 7. Create a new report object and a query

On the Home tab, first click Report Object, then Click here to define a new Query.

The New Report Object tab in DBxtra Designer.

Step 8. Select the data connection

Select the data connection, then click Select.

The Select Data Connection dialog.

Step 9. Build the SQL query

On the Query tab, select the tables and columns to retrieve, and define relationships if needed. The generated SQL query is displayed in the SQL pane.

The Query tab of the New Report Object with selected tables and fields.

Step 10. View the retrieved data

Select the Data Grid tab. The data is displayed in a table.

The Data Grid tab of the New Report Object.

How to download, install, and configure Devart ODBC Driver for Microsoft Excel Online

  • Windows

Download the driver

Click Download in the upper-right corner of this page. Under Download for Windows, click Download next to the EXE or MSI file or—if you're not signed in—click Get Trial, sign up or sign in to your Devart account, and then click Download next to the needed file.
Download 30-day Trial

Install the driver

Run the downloaded installer. Click Next and follow the instructions.

Install the driver

Start the trial period or activate the driver

If you don't have an activation key yet, select Trial; if you've already purchased a license, select Activation Key and enter your key. Then, click Next. To complete the driver installation, click Finish.

Start the trial period or activate the driver

Open ODBC Data Source Administrator

Click Start on the taskbar, type ODBC Data Sources, and select a matching result. The ODBC Data Source Administrator opens.

Open ODBC Data Source Administrator

Add a data source (DSN)

Go to the User DSN or System DSN tab and click Add. Select the driver and click Finish.

Add a data source (DSN)

Configure the data source (DSN)

On the General tab, enter a Data Source Name, Description, and other details required to connect to the data source.

Configure the data source (DSN)

Complete the configuration

Click Test Connection to make sure that all details are correct. Then, click OK to save the data source and complete the configuration.

Complete the configuration

Key features

Platforms Variety

Platforms variety

ODBC can be used with 32-bit and 64-bit applications on both x32 and x64 platforms

Performance Features

Performance features

  • Connection pooling
  • Batch updates
  • Prepared statements
Unicode Support

Unicode support

Full Unicode compliance for all character sets

Standard SQL

Standard SQL

  • Aggregate functions
  • Array functions
  • Datetime functions
Advanced Data Conversion

Advanced data conversion

Bi-directional mapping between DBxtra and ODBC data types

Simple Deployment

Simple deployment

  • Single driver installation, no additional components
  • Support for all Microsoft Excel Online versions

Ready to get started?

Get started with ODBC Drivers at no cost

Get started with ODBC Drivers at no cost

Download our ODBC Drivers for a FREE 30-day trial and see them in action today!

Try ODBC Universal Bundle

Try ODBC Universal Bundle

Get universal access to data of different ODBC-compliant data sources, including major database servers and cloud services.

Need a hand?

Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with our team.

Popular DBxtra integrations using other ODBC drivers for data management tools