Data sources

Integrating Excel via ODBC

The following screenshot shows the ODBC data sources dialog.


The ODBC connection to Excel is only possible with installed 64-bit ODBC driver or 64-bit Microsoft Office package!

ODBC login screen

If it should be possible to change data within Excel, the addition [ReadOnly = 0] in the connection string is necessary.

Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\MyExcel.xlsx;ReadOnly = 0;

Before the data can be loaded, a suitable load command must be formulated. In Excel, the reference to the corresponding table sheet is made via [MyTable$] and has the following form based on SQL:

SELECT [Table Column 1], [Table Column 2] FROM [MyTable$]

Afterwards a load interval can be assigned and the data can be loaded via Load data. Finally, everything is confirmed with OK.

The Excel file is now connected via the ODBC interface and can be used like any other data source.

We are learning from you!

Did you find this article helpful??

Be enlightened!

Do you need more support?

Peakboard Youtube icon Visit our YouTube channel

Our numerous videos for beginners and advanced users explain exactly how to design your dashboard.

Peakboard Templates icon Visit the Peakboard Templates

Download our templates for various use cases for free.

Peakboard icon Visit

Find out all about Peakboard and browse our different use cases and success stories.