This site requires JavaScript to be enabled

Tosca Version
IncidentLookup using list
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

How is the Microsoft Office Open XML formats * .xlsx and * .accdb accessed via ODBC?

Short summary what this article is about


To access the Excel and Access format * .xlsx and * .accdb via ODBC connection, ODBC drivers must be installed. These are included in the Microsoft Office installation by default, but can also be installed separately without the Office package. 2007 Office System Driver: Data Connectivity Components (Link) Microsoft Access Database Engine 2010 Redistributable (Link) Regardless of the operating system, Q-up always uses the 32-bit version The ODBC driver, therefore, the 32-bit versions of the drivers must also be downloaded and installed. Important: Installing Microsoft Office 2010 in the 64-bit version does not include any current 32-bit ODBC drivers, so it is not possible to connect to * .xlsx and * .accdb files. The 32-bit ODBC drivers can only be reinstalled with the package

"2007 Office System Driver: Data Connectivity Components".

The package in the 2010 version refuses to install it.



[opt.] Reference



Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial