
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.