Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

OLE DB data connections - Add entry for Extended Properties

armandfrigo
Partner Ambassador
Partner Ambassador

OLE DB data connections - Add entry for Extended Properties

When creating an OLE DB data connection, there is only one data source field (file path or server name).

It would be a great addition to have a field to add custom "Extended Properties".

For instance that would allow to create OLE DB data connections to Excel binary files (xlsb) with the Microsoft.ACE.OLEDB.12.0 driver by simply adding Extended Properties="Excel 12.0;HDR=YES";

This driver shows up under the name "Microsoft Office 12.0 Access Database Engine OLE DB Provider"

Without this option, the current workaround involves first the creation of a data connection to an Access DB (.accdb), then the update of the data connection from the QMC to replace this with the Excel binary file (.xlsb) and the addition of extended properties. 

 

Tags (1)
1 Comment
P-O_Davidson
Employee
Employee

Although this capability could be of value, we currently do not plan to address this on the roadmap. We will continue to re-evaluate our priorities to see if this can fit in sometime in the future.

Status changed to: Closed - Declined