connect database: Open a database connection using a connection string.create connection string: Generate a connection string for a specified database on a given host.They are listed in the typical order of their workflow: TestArchitect provides the following built-in actions for working with SQL-compliant databases. If Microsoft Office is not currently installed on your test machine, you can download and install the correct driver from the appropriate link below: Excel: The ODBC driver for Microsoft Excel is automatically installed with Microsoft Office.Should you need to obtain the ODBC driver installer for your particular data source, following the appropriate link below: A list of installed ODBC drivers is available under the Drivers tab. Windows: Open the ODBC Data Source Administrator dialog box.The following utilities may be used to determine whether the correct driver is already installed:

The correct driver must be specific to both the DBMS and the architecture (64-bit) of the TestArchitect Controller application that uses it. Microsoft Excel Supported Extensions: xls, xlsx, xlsm, xlsb.Ĭonnecting to and querying a database from a test requires that the correct ODBC driver be used.

Supported Microsoft Excel versions: 2007, 20. Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows. Information specific to testing with Microsoft Excel Introduction

Excel driver for odbc download