Performance depends on the computing power of the client machine, network speed, search complexity, and data volume.įor more information, see the Use the Query Wizard to define a query topic in the Microsoft Office documentation. In the Navigator menu, select your saved search from the list, and click Load.If it is not, an installer may be downloaded from Microsoft for the Excel ODBC driver. This is usually installed with a Microsoft Office installation. Microsoft connects to your Splunk platform server. The Excel ODBC driver must be installed on each QuerySurge Agent box, because the Agent uses a JDBC-ODBC bridge to connect to the files through this driver. The test system is a debian v11 (bullseye). Refer to SQLite for installing the required ODBC Driver Manager.

I use EXCEL 2016 (32 bit) and I get Information, to install the ODBC driver 32 bit. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here. Hi all, I successfully installed the 18 c XE (64 bit) The connect with DSN was successfull too (64 bit).

In the ODBC driver window, enter the username and password for your Splunk platform instance, and click Connect. This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and MariaDB.

In the Navigator window, select ODBC > All from the Display Options menu.

In the From ODBC window, select Splunk ODBC from the Data source name (DSN) drop-down list, and click OK. C ODBC Connection String for Access & Excel Build connection strings and enumerate installed ODBC drivers (32bit and 64bit) ODBC Drivers Install ODBC Driver.

In the Data tab, click Get Data > From Other Sources, and click From ODBC.

In Microsoft Excel, open a new worksheet.

Configure the Splunk ODBC driver to work with Microsoft Excel on Microsoft Windowsįollow these steps to Configure the Splunk Open Database Connectivity (ODBC) driver to work with Microsoft Excel on a Microsoft Windows system.

Install excel odbc driver