VBA - Problem getting data from Oracle server using SQL query with Recordset

So it's a table with about 60 columns and hundreds of rows. The query returned the correct rst.field.name but the rst.field.value is only returned for the first row, and there should be hundreds.

I want to further filter this down after but if this first step doesn't work I can't go any further.

Really? But fields.count only equals the number of columns and there only seems to be one row of data

Ok Thanks. What is the best way to gather the data?

So the moment I just want to see data for a few rows. Say the first three rows

Hi Dapos, and welcome to the forum. Sorry to interrupt, but please notice that I have added code tags to your original post. The forum rules require their use so please keep that in mind when showing code in any future posts. Thanks.

Here's the rule:

RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hi,

Apologies for not using the code tags. Will use from now on.

JosephP, thanks for your help. Stupid on my part, I assumed I would be able to see everything from the watch window.

That worked a treat now. I used the following

Please Login or Register  to view this content.

Thanks again,

Dapos.

It appears, based on your last post, that your thread can now be marked as SOLVED. I'll do that for you now but please remember to do it yourself in your future threads. Thanks.