How to extract Field name and Date type of a table to Excel

hi,

I want to extract the field and data type from the table in AX 2012 R3 to Excel Sheet, can anyone help me with this.

THANKS.

If you want to do it from AX, you can use X++ reflection (e.g. DictTable class) to read the metadata and SysExcel* classes to create Excel files.

If you want to do it from outside AX, the Metadata service looks like the best choice.