Search:     Advanced search

QA Wizard Pro OpenRecordsetQuery Statement Returns Database Engine Could Not Find the Object Error

Article ID: 800  |  Last updated: 07 Jun, 2017


When running a script that uses the OpenRecordsetQuery function to create a data set from an Excel datasheet, playback fails and the following error is returned: 

'The Microsoft Jet database engine could not find the object.'


The query argument in the OpenRecordsetQuery function does not correctly specify the Excel worksheet to use. 


Use square brackets and a dollar sign in the second argument of the OpenRecordsetQuery function to specify the worksheet. The following example shows the correct syntax.

query = "Select * FROM [Sheet1$]" 

dataset = OpenRecordSetQuery("WysiCorp Excel Data", query)

Article ID: 800  |   Last updated: 07 Jun, 2017
Excel OpenRecordsetQuery Jet database engine could not find object

Prev   Next
Silverlight Applications Stop Responding in Internet Explorer...     Controls Duplicated in the QA Wizard Pro Application Repository