How to Get the Data Type of Columns in access

Question

I want a query that returns the column names and data type for each column in access

This is a code in Oracle, the same idea in Access How

select COLUMN_NAME, DATA_TYPE from user tab columns where table name=your table name

Answer 1

In Access, you can't use SQL for that.
Use DAO to open the table and read the data types of the fields looping the Fields collection of the table.