Copying Access column from one table to another using SQL

[mokaplanjr]

I need to use SQL to copy a column from one Access table to another in order to get that column's properties (i.e. "Allow Zero Length"). Using alter table to add a column will not allow setting "Allow Zero Length". In other words I want to copy TableA.ColumnX to TableB.ColumnX. Once copied, I can rename (if necessary) and populate the column with the data I want.
I've tried the following in a cfquery tag:
"SELECT TableA.ColumnX INTO TableB FROM TableA" without success. I've attempted some other queries as well. None work.
Any takers?
Thanks in advance.