Return headers with results in Recordset

[mc84excel]

I'm pulling data from SQL databases using OLEDB.

I can return the data (without headers) by using

Please Login or Register  to view this content.

or

I can return the headers only by using

Please Login or Register  to view this content.

How can I return the data with its headers using the same recordset? (I'm joining the two arrays from above but it's inefficient. I want to do this in one operation.)

[Kyle123]

Unless I’ve missed something, Like this: https://stackoverflow.com/questions/...aders#24283834

[mc84excel]

Thanks for the suggestion Kyle. That looks like the code loops through the recordset fields and pastes them to a range (then pastes the rst contents to the range)

I'm hoping that there is some advanced parameter which would allow me to set an array variable by

Please Login or Register  to view this content.

(or nearest equivalent) and have the field names in the first record of the array.

Your suggestion is helpful in that I could bring 2 recordsets down to 1 however I would still need 2 array variables and then merge the 2 arrays together to get the desired output.

[Kyle123]

There isn’t, you’ll need to loop through the headers, put them in an array and merge them with the data array.

[mc84excel]

That's what I was afraid of. Oh well, can't be helped. Will have to merge the two arrays then. Thanks Kyle.

(In case anybody reading this wants to know what possible use for the header/field names included in the array = You can paste the array into an Excel workbook and it already has the field names, ready for inserting a table.)

[Kyle123]

You can, but you wouldn’t use getrows for that. You’d use copyfromrecordset