use field names in ADODB query to an Excel workbook

Hi,

for a number of a circumstances I am trying to read from excel files as if they are databases to use the recordset in a VBA macro.
it all goes nice and well, but I cannot use fieldnames on my query, I have to use SELECT * FROM ...
and then use fieldIndex when extracting information with getRows(fields:=fA) where fA is a field index array

I have tried puting names in brackets [], forward ticks, `` and nothing at all but nothing seems to work.

Please Login or Register  to view this content.

however, I do have managed to use field names in queries of querytables
but have no idea how to achieve the same in code

with the macro recorder I did get something as follows

Please Login or Register  to view this content.

Anyone can iluminate me?
Thank you!

Because error occurs, failed to mention that.
using * is the only way to get something

Nevermind, seems to be working now...
but I have a feeling I'll be back soon.

FWIW: if someone is here fighting with queries on excel files, you can concatenate fields putting like SELECT ([Field 1] & [Field 2]) as [Alias] FROM [Sheetname$]