How to do derive column headers of a table with query

[BizBoy]

Hi,

I have imported an excel worksheet manually in MS Access. Table name is ‘Employee Directory’.
This table has 13 column headers. How do I write a query which will give list of these 13 headers.

Can anyone please help me in this.

 

[Joe4]

Access queries only act on data, not on the field names.
What you want to probably requires VBA.
Here are a few links that show you how you can do that:
http://software-solutions-online.com/access-vba-get-field-names/
https://www.ozgrid.com/forum/forum/...tabase-vba-method-to-return-table-field-names
https://www.devhut.net/2010/06/10/ms-access-vba-list-query-fields/

 

[BizBoy]

Hi Joe, sorry for late reply. I was not feeling well hence delay in reply.

Thanks for the help. Have a nice day ahead.

 

[Joe4]

You are welcome.