Import Access table including Headers into 2d Array- Using ADODB Record set

Hello,

I am trying to import data from Access table including headers into an 2d Array, using the below code only getting the records not the fields names.

Kindly help

Please Login or Register  to view this content.

Thanks
Jude

You can add it manually with this logic. The number of fields must be equal.

Please Login or Register  to view this content.

I trying get dynamic without adding manually

For example try:

Please Login or Register  to view this content.

You now have a 'ttl' variable (with the field names) and you can create from it (as well as from the 'snEmp' variable) a "cumulative" array of field names and data (or insert data from these variables in separate lines of code).

Thanks, it helped, i merged ttl with snEmp data