Search:     Advanced search

OpenRecordsetQuery Statement Returns Database Engine Could Not Find the Object Error

Article ID: 800  |  Last updated: 23 Dec, 2014


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: 23 Dec, 2014
Excel OpenRecordsetQuery Jet database engine could not find object

Prev   Next
Silverlight Applications Stop Responding in Internet Explorer...     Capturing Web Page Text with Functions