Get recordset without the headers

Hi all,

I use the below code to connect to a database and get the data into excel sheet. I wanted to get the recordset without the headers, but I simply can't find out how to do it. 2 hours of google did not give me any results.
Is there actually a way to do this with the below example?

Greetings.

Please Login or Register  to view this content.

Hi Cytop,

Thanks a lot, it really works :-)
Sily me I did not see the field names in the code and to set it to false :-(

In the above example, I use it on an Access database, but in actual work, I use it to connect to a Teradata database. When I created the solution after recording a macro and getting to know more or less how it would look like, I never managed more than the above code.

Will it work faster if I dont create the Query Table as in the above code and use your solution?

Greetings.

BIG THANKS, you are always a very helpful person :-)

Greetings,