Microsoft Excel is, of course, not a database. However, INETAPP comes with a dedicated database driver to allow connecting an Excel file. Using this connection type you do not have to create an ODBC data connection, as is required with, e.g. MS Access.
To create a new database connection to an Excel file, you have to make sure, that the file is accessible in the file system of the server. You can, for example, use the repository to upload the Excel file, and store it in a location where no other user has access to it.
Now create a connection in the configuration with the following settings:
Other
- you have to configure the connection manuallyjdbc:inetexcel:<PATH ON SERVER>?hasHeaderRow=true
The username and password are usually not required.
The PATH ON SERVER
placeholder has to be filled with an absolute file path in your hosts operating system. Here is an example:
# JDBC URL for Excel file in dockerized server, using the repository jdbc:inetexcel:/home/helpdesk/.i-net software/helpdesk_User_Default/reports/User/Users.xlsx?hasHeaderRow=true