Knowledgebase

Search:     Advanced search

OpenRecordsetQuery Statement Returns Database Engine Could Not Find the Object Error

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

Problem

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.'

Cause

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

Solution

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
Tags
Excel OpenRecordsetQuery Jet database engine could not find object

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