MS Excel
Microsoft Excel is, of course, not a database. However, i-net HelpDesk 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 Drive 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:
-
Type:
Other
- you have to configure the connection manually -
URL:
jdbc:inetexcel:<PATH>?hasHeaderRow=true
The username and password are usually not required.
The PATH
placeholder has to be filled with the file path in the Drive, which can be copied using the Copy as Path
action on the file in the drive. Here is an example:
# JDBC URL for Excel file in the Drive root jdbc:inetexcel:drive:User.xlsx?hasHeaderRow=true