Data sources

通过ODBC集成Excel

The following screenshot shows the ODBC data sources dialog.

Note

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.

How data can be written to Excel with this connection can be found here.

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 www.peakboard.com

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