Issue in querying the Reporting Services exported Excel

R

Raj

I exported a Reporting Services report into excel and trying to query the
excel as described below:
objRecordset.Open "Select * FROM [TestReportSheet$]", _
objConnection, adOpenStatic, adLockOptimistic, adCmdText

objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\MyExcel.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;"";"

This returns zero rows even though there are 500 rows.

But if I copy the same data into different spreadsheet and try the above
code it works fine.

Is there anything that I am doing wrong in the first case?

Thanks in advance for any suggestions and help. I am posting this in
reporting services forum also.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to release the memory taken by a Recordset Object ? 1
ADO connection not opening in Excel 2003 0
How to use ADOX on Excel? How to automate Excel invocation on existing xls file from vbs? 0
Using ADO to Query Excel 0
Excel Sheets Opens Itself Again After ADO Query ! Please Help It's Urgent ! 8
ADO Recordset 0
ADO connection to Excel 2007 *.xlsx files? 8
export excel data to access table using ADO 0

Top