how can copy column headers name by VBA MS Access

Question

how can copy Table column headers name by VBA MS Access to paste them in other table

Answer 1

Hi,

You can loop through the TableDefs' Fields collection.

Hope it helps...