import columns From Excel macro do not import user_data type properly

We created several user defined data type, such as TIME, TIMESTAMP, STRING. I manually enter entity/field into model is fine. But when user macro import from Excel, all those user data types be converted into the data type CHAR(0)..

I have many STRING field (it is for bigQuery) and manually make correction from ER/Studio manually is too much.

works.

I wondering if someone have a way to work around on it.

Thanks,

Ann